MS Access 2003 - Good book on learning advanced VBA

Question

Hey guys! Was wondering is anyone had any suggestions on books or other resources on learning novice to advanced VBA as it relates to access programming. I have bought and read the "Access Bible", "The only access book you'll ever need", and "Sams TY in 21Days" and they were all fine for learning the basics.

Then I bought and read teh O'Rielly Programming book and thought it was great (a little more gratifying, and I learned a lot more with this book rather than the others). So I am kinda looking for something more alnog the line of this one...the more examples the better.

Appreciate the advise; thanks.

Answer 1

Access Developer's Handbook was the best by far.

VBA Developer's Handbook, 2nd Edition is also excellent.

Answer 2

Since you asked specifically about books, I'll suggest O'Reilly's Access Cookbook. I found that one useful for an intermediate level approach to Access VBA.

Other than books, the biggest gain for me has been participating in the microsoft.public.access newsgroups. It gives me an opportunity to study the approaches of many real Access experts. And when I reply to questions I get to benefit from their review.

Answer 3

I was quite satisfied with Access 2003 VBA Programmer's Reference here is a link to the 2007 version.