Summary
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
11.5. Summary
Using the right combination of report sections, controls, and properties, there are many forms tasks in Access that can be completed without VBA code. The key to learning the difference of when to use VBA, and when not to, lies in the examination of not only the properties of every object, section, and control, but also the settings of those properties.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.