Book Suggestions for VBA Development and Sample Databases

[PSULionRP]

Ok. I am really starting to get into Microsoft Access VBA and am wondering
what book suggestions you all might have for developing Microsoft Access VBA.
I deal with what seems like a lot of fragmented VBA code all over the place.
And our Access Apps are pretty slick in terms of creating dynamic Excel
spreadsheets, generating e-mails, accessing Oracle thru ADO and the like.

So any suggestions you might have in terms of better organizing our VBA
Modules and any good web sites out there for accessing Sample Access Database
and applications would be GREATLY appreciated!

Thanks for your review and hopeful for some replies.

Thanks!

PSULionRP

 

[Arvin Meyer [MVP]]

There are tons of links to great Access websites. In addition to those in my
sig, you will find dozens at the other users listed there. These 2 are
especially good for links:

http://www.mvps.org/access

http://www.accessmvp.com

 

[John W. Vinson]

Ok. I am really starting to get into Microsoft Access VBA and am wondering
what book suggestions you all might have for developing Microsoft Access VBA.
I deal with what seems like a lot of fragmented VBA code all over the place.
And our Access Apps are pretty slick in terms of creating dynamic Excel
spreadsheets, generating e-mails, accessing Oracle thru ADO and the like.

So any suggestions you might have in terms of better organizing our VBA
Modules and any good web sites out there for accessing Sample Access Database
and applications would be GREATLY appreciated!

Thanks for your review and hopeful for some replies.

Thanks!

PSULionRP

The best VBA reference (and far more) that I've ever seen is Getz and Litwin's
awesome _Access 2000 Developer's Handbook_, published by Sybex. It's huge and
it's not cheap, but I've gotten at least ten times its cost back in saved time
and improved applications.

See also the references in:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials