Tips and Tricks
by Armen Stein, Graham Seach, Teresa Hennig, Patricia Cardoza
Access 2003 VBA Programmer's Reference
- Copyright
- Dedication
- Credits
- About the Authors
- Contributors
- Acknowledgments
- Foreword
- Introduction
- Introduction to Microsoft Access
- Access, VBA, and Macros
- New Features in Access 2003(and 2002)
- VBA Basics
- Using the VBA Editor
- Using DAO to Access Data
- Using ADO to Access Data
- Executing VBA
- VBA Error Handling
- Using VBA to Enhance Forms
- Enhancing Reports with VBA
- Creating Classes in VBA
- Extending VBA with APIs
- SQL and VBA
- Working with Office Applications
- Sharing Information Is a Two-Way Street
- Access and Outlook—Sharing Data with Others
- Sending Information from Access to Excel
- Exchanging Information with Microsoft Word
- An Advanced Example—Creating a Graph in Access and Inserting It into PowerPoint
- Using the Access Object Model to Pull Data from Access to Other Applications
- Summary
- Database Security
- Understanding Client/Server Development with VBA
- Working with the Win32 Registry
- Using the ADE Tools
- Macro Security
- Appendices
- Upgrading to Access 2003
- References for Projects
- DAO Object Method and Property Descriptions
- ADO Object Model Reference
- The Access Object Model
- The Application Object
- The CodeData Object
- AllDatabaseDiagrams Collection
- AccessObject
- The AllFunctions Collection
- Other Similar Collections
- The CurrentData Object
- The CodeProject Object
- The CurrentProject Object
- The DataAccessPages Collection
- The DataAccessPage Object
- The DefaultWebOptions Object
- The DoCmd Object
- The Forms Collection
- The Control Object
- The Module Object
- The Section Object
- The Printer Object
- The References Collection and Reference Object
- The Reports Collection and Report Object
- The Screen Object
- The SmartTag Object
- The SubForm Object
- The SubReport Object
- Other Helpful Information
- Windows API Reference Information
- Naming Conventions
- Reserved Words and Special Characters
- Tips and Tricks
- ADO Object Argument Information
- Access Wizards, Builders, and Managers
- Windows Registry Information
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.