Access 2007 VBA Programmer's Reference

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.

User review
Good overview of new features, with much sample code
A very helpful reference to have by your side, as well as a good introduction to what has changed in working with Access 2007 compared to its predecessors (and much has changed). This books does a better job of sorting it all out than previous ones I have tried.

The book has a decent index, and sample code just about everywhere, so I have learned a number of new VBA techniques as well. A good purchase.

User review
Minimal 2007 conversion details
I purchased this book in main part because the description suggested that it addressed the 2007 changes in Access, including helpful information in upgrading to 2007. However, I felt that clearly was the not case. Yes, it contains typically found information that applies to the 2007 version, but is virtually absent real detail providing specific guidance on the problems and complexities that can be encountered in VBA, Ribbon use, and references when converting Access 2002/2003 up to 2007. No details regarding managing old toolbars converted to Add-in tabs. No details on which old VBA does not convert, or causes predictable conflicts. No details on reference conflicts that can cause immediate problems. I expected more from four professional Access developers. Having now converted Access databases, I've found multiple code differences that could have been brought to my attention that would have saved me subtantial trial and error time loss. Should I have expected more conversion information detail? Normally when going from one version to another, I would find it helpful but not critically important. However, because of the huge impact of Microsoft's new user interface, as well as VBA changes - and their impact on existing prior-version databases - conversion detail would be extremely valuable. So only based on this targeted expectation from this book, I would not recommend it over any other Access book - with regards to usefulness in dealing with conversion problems and complexities.

User review
Access 2007 VBA
This is the book to have for learning the skills of writing useful apps and background routines that make your Access programs fly and professionally useful.

User review
This book Rocks!
I have definitely come to respect the Wrox writers. Whenever I am in need of additional assistance, I look to these books first. The Access 2007 VBA Programmers Guide has everything I need in it and is written in an easy to follow manner. My skill level is just above beginner, but there are sections of the book for more advanced programming that I have not looked at. I highly recommend all books by Wrox (I have used their SharePoint books extensively).

User review
Excellent!
This books was a TREMENDOUS help in writing a Human Resources application for my company. I'm no programmer--but this book helped me a great deal with some of the VB that was needed for the database. I did also rely on the internet a lot but this was a handy tool that covered a majority of the basics--the internet was for more advanced scripting. I highly recommend the book for those who work with Access often,,.and even for those who want to take advantage of the cool things code will enable you to do.