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

Access 2007 VBA Programmer's Reference (Programmer to Programmer)
Authors
Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Armen Stein
ISBN
0470047038
Published
14 May 2007
Purchase online
amazon.com

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.

Page 2 of 2
  1. Editorial Reviews
  2. Customer Reviews

Customer Reviews

R. Gillingham said
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.

William Hamilton said
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.

Melissa Vegter said
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).

S. A. Hards said
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.

Robert Larson said
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

You might also like...

Comments

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“In order to understand recursion, one must first understand recursion.”