Book description
Covers all features of VBA programming for Access database applications
Begins with an overview of VBA and highlights what's new in Microsoft Access 2003, the most popular database system in the world
Real-world code examples demonstrate each programming topic, including using the Access Object Model, VBA execution and error handling, creating database objects with VBA, writing secure VBA code, and much more
Shows how Access 2003 provides enhanced XML support, making it easier for programmers to publish data to the Web and exchange it with other organizations
Table of contents
- 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
- Index
Product information
- Title: Access 2003 VBA Programmer's Reference
- Author(s):
- Release date: April 2004
- Publisher(s): Wrox
- ISBN: 9780764559037
You might also like
book
Access™ 2007 VBA Programmer's Reference
This resource provides the tools you need to leverage Access 2007's built-in functionality and VBA in …
book
Excel® 2007 VBA Programmer's Reference
Get ready to take your Excel applications to the next level by harnessing the power of …
book
Access 2007 Programming by Example with VBA, XML, and ASP
Access 2007 Programming by Example with VBA, XML, and ASP shows non-programmers how Access databases can …
book
Beginning Access™ 2007 VBA
This book provides you with the tools and techniques you'll need in order to build more …