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
1.7. Summary
The various sections in this chapter detail a few of the ways you can automate your Access application without writing any code. However, this is a book about Access 2003 VBA, so you're probably wondering when we're going to write some code. Stay tuned. Chapter 2 introduces you to the basics of VBA development. If you're experienced in VBA you can probably skip this chapter; however, if you are new to VBA development, or you just want a refresher course in some of the basics, be sure to read Chapter 2. The rest of the book breaks down VBA in Access into manageable topics, going into detail about each one.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.