Access 2007 VBA Programmer's Reference (Programmer to Programmer) (Paperback)

by Teresa Hennig (Author), Rob Cooper (Author), Geoffrey L. Griffith (Author), Armen Stein (Author)
Key Phrases: accde file, mdw file, accdb format, Private Sub, Microsoft Office, Close Set (more...)

Editorial Reviews

Product Description
This resource provides the tools you need to leverage Access 2007’s built-in functionality and VBA in order to build more dynamic applications. The author team explores all aspects of VBA programming for Access, describes the latest innovations, and explains how to take advantage of key new objects, enhanced macros, and the Office Ribbon. Plus, you’ll 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.

From the Back Cover
Access 2007 VBA Programmer's Reference

Written 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 ActiveX® 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 book

• All about Access 2007's new features and the building blocks of VBA

• Ways to debug your code and avoid common pitfalls

• Techniques for accessing data in Access and other external data sources

• Steps for creating and enhancing forms and reports

• Methods for controlling access to your applications and files

• 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 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.

See all Editorial Reviews

Product Details

• Paperback: 1152 pages
• Publisher: Wrox (May 14, 2007)
• Language: English
• ISBN-10: 0470047038
• ISBN-13: 978-0470047033
• Product Dimensions: 9.5 x 7.3 x 2.7 inches
• Shipping Weight: 3 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars See all reviews (11 customer reviews)
• Amazon.com Sales Rank: #11,008 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #5 in	Books > Computers & Internet > Microsoft > Development > VBA
  #41 in	Books > Computers & Internet > Databases

Customer Reviews

Most Helpful Customer Reviews

14 of 15 people found the following review helpful:

5.0 out of 5 stars Excellent Self-Study for Access 2007 VBA, May 10, 2007

By	Larry Linson, Access SIG Leader, North Texas ... (Dallas - Fort Worth, Texas Area) - See all my reviews

This book has extensive coverage of an area vital to Access developers and power users, by a very knowledgeable team, ably led by Teresa Hennig. It includes something more than an overview explaining new features of Access 2007. That is important because: many features are new and changed in Access 2007, much of what we do with VBA is automating and enhancing features we use manually via the user interface, and the new Office 2007 user interface can be overwhelming without a helping "hand up". Then the book covers VBA from the basics to in-depth advanced levels. It is a worthy successor to the Access 2003 VBA Programmer's Reference and, in my opinion, "raises the bar" for VBA books. I'll be using it as a reference in presentations to my Access user groups, as well as a handy reference for my own work. I recommend it to Access power users, as well as aspiring and working Access developers.

Larry Linson
Microsoft Office Access MVP (see http://mvp.support.microsoft.com)
Co-Leader, Access Special Interest Group, North Texas PC User Group

9 of 9 people found the following review helpful:

5.0 out of 5 stars Great Resource for ANYONE working with Access, March 18, 2008

By	Robert Larson "Bob Larson" (Portland, OR) - See all my reviews (REAL NAME)

Access 2007 VBA is a great book for experienced and novice programmers alike. It is thoroughly detailed and yet covers the VBA basics at the beginning. What I like about this book is that it covers details that other books seem to always miss. This would include Microsoft Office integration. Or, in other words, the code that lets you work with other Office applications like manipulating Excel from Access or Word from Access. It also goes into working with Outlook and even SharePoint, which are two of the hardest to find information on when working with Access VBA. I am finding this book to be a great addition to my library and I believe you will too.


Bob Larson
Access World Forums Super Moderator
Utter Access VIP

12 of 13 people found the following review helpful:

5.0 out of 5 stars Great Desk Reference and Self paced study system., June 3, 2007

By	Truitt L. Bradly "Microsoft Access MVP 2007 &... (Austin, TX) - See all my reviews (REAL NAME)

My copy of the Access 2003 VBA was well worn by the time Access 2007 VBA Programmer's Reference became available. This new book is well written and organized and it is a great successor to the previous version. The team did an excellent job explaining and illustrating the new features in Access 2007, as well as the features that existed in previous versions of Access.
There are many new features in Access 2007 and this reference helps the developer get the best performance from Access 2007.
I would recommend this book for all skill levels.