Access 2007 VBA Programmer's Reference
Written by Access MVPs and Microsoft Access testers, thisresource will give you the tools to leverage Access 2007's built-infunctionality and VBA in order to build more dynamic applications.It explores all aspects of VBA programming for Access and describesthe latest innovations. You'll also find several commonly usedtechniques and sample code to help you get started, as well asexpert tips to make your code easier to maintain.
The expert author team will show you how to create and namevariables, manipulate data using Data Access Object (DAO) andActiveX® Data Object (ADO), handle errors, and create classes.You'll also learn how to utilize the latest wizards as well asmodify and enhance the code that the wizards create. And you'lllearn how to take advantage of key new objects, enhanced macros,and the Office Ribbon.
What you will learn from this book
- All about Access 2007's new features and the building blocks ofVBA
Ways to debug your code and avoid common pitfalls
Techniques for accessing data in Access and other external datasources
Steps for creating and enhancing forms and reports
Methods for controlling access to your applications andfiles
How to use VBA with APIs and other Office applications
Tips for using the Windows® Registry and ADE tools
Who this book is for
This book is a comprehensive resource for Access users and VBAdevelopers who want to increase the power of Access using VBA.
Wrox Programmer's References are designed to give theexperienced developer straight facts on a new technology, withouthype or unnecessary explanations. They deliver hard informationwith plenty of practical examples to help you apply new tools toyour development projects today.