Using the VBA Editor
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
Chapter 5. Using the VBA Editor
You'll use the VBA Editor to write almost all of your VBA code. While you can simply enter the VBA Editor and start typing code, knowing a bit about the different components of the VBA Editor can help you properly structure and debug your code. In this chapter, we'll examine the major structural components of the VBA Editor as well as some basic code debugging techniques.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.