Need a Good Book on Access VBA

[apryor]

I'm starting a project with Access and it's looking like it is going to require some special customization. Possibly using VBA. The problem of course being that I'm not very familiar with VBA. Can anyone recommend a good book to get me up and running and learn it?

Additionally, this is one of the features of the Access db I will need to create. From the initial screen, Form or switchboard, I would like to input several pieces of info, such as contact data, prices, dates, etc, then click a button, which opens a form and the previously entered data is transferred over.

Any help is very much appreciated. Thanks

 

[SBendBuckeye]

Don't forget your local library. Perhaps they have a For Dummy's version to help you get your feet wet without actually spending the money on it (I say that because once you've used VBA a bit you won't ever refer to it again). An excellent resource if you are not easily intimated by tons of information is Access Developers Handbook by Ken Getz, etx. by Sybex. It is a 2 volume, 3-4" thick each volume set. You can buy it reasonably on eBay or Borders used if you look around. Also, Wrox press has good intro material. You might even go to Borders or Barnes and Nobles and check out some of their stuff before you buy it. Good Luck!

Have a great day!

j2consulting@yahoo.com

 

[SBendBuckeye]

I forgot one of my favorite publishers, Que. I always recommend them highly in the Excel classes I teach. They are written more from a Power user standpoint. Good LucK!

Have a great day!

j2consulting@yahoo.com

 

[daddypost]

Wrox "Access 97 programming with VBA" is a great book to get you where you need to be. I've used it as a reference for a while now. It will show you how to synchronize combo boxes to forms, use lookups to find data, how to carry values from one form to another as well as more complex vba like designing search criteria forms that make a table with criteria hits in it. It has helped me tremendously and every bit of code is explained in detail as to why and how its being done.

Good luck to you. You're about to learning process that never ends, because no matter how much you know, you don't know the half of it.

 

[apryor]

Thanks for your help Guys, I'll be stopping by Barnes & Noble after work today to check out those titles and anything else I can find.

AP