Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Access 2007 VBA Programmer's Reference 1st Edition

4.4 out of 5 stars 35 customer reviews
ISBN-13: 978-0470047033
ISBN-10: 0470047038
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$10.92 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$28.74 On clicking this link, a new layer will be open
More Buying Choices
24 New from $11.24 36 Used from $1.42
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$28.74 FREE Shipping. Only 6 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • Access 2007 VBA Programmer's Reference
  • +
  • Access 2007: The Missing Manual
Total price: $55.97
Buy the selected items together

Editorial Reviews

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.

About the Author

Teresa Hennig  is president of both the Pacific Northwest Access Developer Group and the Seattle Access Group, and is host for INETA’s monthly webcasts. She was the coordinating author for Access 2003 VBA Programmer's reference, and continues to publish two monthly Access newsletters. In recognition of her expertise and dedication to the Access community, Teresa was awarded Microsoft Access MVP.

Rob Cooper is a test lead on the Access team at Microsoft.  During the Access 2007 release, he led the security efforts across the test team and worked on several new features including disabled mode, database encryption, Office Trust Center, and sorting, grouping and totals. Rob also led efforts around the Access object model and continues to provide direction around programmability and security in Access.
A long-time fan of Access, Rob is a frequent speaker at the Seattle Access Group and PNWADG meetings and has written for the Microsoft Knowledge Base and Access Advisor.

Geoffrey Griffith is an avid Access user who contributed to the Access 2007 product as a Software Design Engineer in Test for the Microsoft Office Access team. He enjoys participating in software community events by attending and speaking for local users groups and helping all those who would seek it.

Armen Stein is a Microsoft Access MVP and the president of J Street Technology, Inc., a team of database application developers in Redmond, Washington.  Armen is President Emeritus of the Pacific Northwest Access Developers Group, and has also spoken at Seattle Access and Portland Access Users Group meetings. He has taught database classes at Bellevue Community College, and also developed and taught one-day training classes on Access and Access/SQL Server development.

NO_CONTENT_IN_FEATURE

New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Paperback: 1152 pages
  • Publisher: Wrox; 1 edition (May 14, 2007)
  • Language: English
  • ISBN-10: 0470047038
  • ISBN-13: 978-0470047033
  • Product Dimensions: 7.4 x 2.1 x 9.2 inches
  • Shipping Weight: 3.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (35 customer reviews)
  • Amazon Best Sellers Rank: #840,017 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Laurin M. Linson on May 10, 2007
Format: Paperback
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 [...])

Co-Leader, Access Special Interest Group, North Texas PC User Group
Comment 24 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
2 Comments 13 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I had done very little code writing, and only that which I needed and found by googling. So I found myself writing code for what I needed to happen, but not having a clue of what I was writing. I read the reviews on this book and the 5 star folks are very correct. This is an excellent book for beginners and advanced programmers, which is a tough spread to cover. As a newbie, I was able to self-teach myself the basics of VBA and now am able to read and use advanced code much more easily. Well worth the purchase and I have tabs stuck all over the place. The appendixes were worth the price alone, and the tips they share are valuable. Great job.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I starting developing with Access 97 and have used each version since. I specialize in accounting applications and there have licensed several Access accounting applications for modification. This book addressed (easy to understand format) the areas that affect developers most (the U.I., code, classes). It is definitely for the experienced. It is a welcome addition to my library.
Comment 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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
Comment 12 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 11 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I was pretty new to Access when I got this book, although I do have a pretty good understanding of programming in general. I thought this book was helpful and I was able to make some pretty cool personal databases. I didn't do anything too crazy, but I think this book would have been able to get me there if I needed to. If anything, it's nice to have around and at a reasonable price.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Access 2007 VBA Programmer's Reference
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: Access 2007 VBA Programmer's Reference