Experienced VBA developers who need a comprehensive reference for all of the features of VBA for Access.
Access 2003 VBA Programmer's Reference provides comprehensive coverage of the use of VBA for building Access applications. The typical reader would be expected to have some experience with VBA programming and have read at least an introductory tutorial, such as Beginning Access 2003 VBA. (Note that this book will cover both Access 2002 and Access 2003.)
The authors provides real-world code examples to demonstrate each programming topic, including:
- Using the Access Object Model
- Using VBA with ADO
- VBA Execution and Error Handling
- Creating Database Objects with VBA
- Using VBA to Create and Enhance Forms and Reports
- Using VBA with APIs and Other Office Applications
- Using VBA with SQL
- Creating Secure VBA Code
- Using the Windows Registry
- Using ADE Tools
Contents
Credits.
Title Page.
Copyright Page.
Dedication.
Acknowledgements.
Author Bios.
Introduction.
1. Intro to Access.
2. Access, VBA, and Macros.
3. New Features in 2003 (and 2002).
4. VBA Basics.
5. Using the VBA Editor.
6. Using DAO to Access Data.
7. Using ADO to Access Data.
8. Executing VBA.
9. VBA Error Handling.
10. Using VBA to Enhance Forms.
11. Enhancing Reports with VBA.
12. Creating Classes.
13. APIs.
14. SQL & VBA.
15. Working with Office Applications.
16. Security.
17. Understanding Client-Server Development with VBA.
18. Windows Registry.
19. Using the ADE Tools.
20. Macro Security.
Appendix A: Upgrading to Access 2003.
Appendix B: References for Projects.
Appendix C: DAO Object Method and Property Descriptions.
Appendix D: ADO Object Model Reference.
Appendix E: Access Object Model.
Appendix F: Windows API Reference Information .
Appendix G: Naming Conventions.
Appendix H: VBA Reserved Words.
Appendix I: Tips and Tricks.
Appendix J: ADO Object Argument Information.
Appendix K: Access Wizards, Builders and Managers.
Appendix L: Windows Registry Information.
Index.