Access 2007 VBA Programmers Reference

Access 2007 VBA Programmer's ReferenceWritten by Access MVPs and Microsoft Access testers, this resource will give you the tools to leverage Access 2007's built-in functionality and VBA in order to build more dynamic applications. It explores all aspects of VBA programming for Access and describes the latest innovations. You'll also find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.The expert author team will show you how to create and name variables, manipulate data using Data Access Object (DAO) and ActiveXr Data Object (ADO), handle errors, and create classes. You'll also learn how to utilize the latest wizards as well as modify and enhance the code that the wizards create. And you'll learn how to take advantage of key new objects, enhanced macros, and the Office Ribbon.What you will learn from this bookAll about Access 2007's new features and the building blocks of VBAWays to debug your code and avoid common pitfallsTechniques for accessing data in Access and other external data sourcesSteps for creating and enhancing forms and reportsMethods for controlling access to your applications and filesHow to use VBA with APIs and other Office applicationsTips for using the Windowsr Registry and ADE toolsWho this book is forThis book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA.Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.Griffith, Geoffrey L. is the author of 'Access 2007 VBA Programmers Reference ', published 2007 under ISBN 9780470047033 and ISBN 0470047038.