Recommend Me a VBA Book

Hello

This forum has been fantastically helpful to me as an "advanced novice" Access creator - I have learned tons!

I would like to ask you all for recommendations for a good reference/learning book about VBA. I am not a programmer, nor do I want to study some 800 page programmer's jargon book ( no offense to you programmers!), but I also don't want the level of "VBA for Dummies" either. To give you an idea - main book sources that I use are The Access Bible and Microsoft's Access VB Step-by-Step. I also tinker with the VB Learning Edition software and books too. I like stuff that has examples and theory mixed in.

Thanks!
Milin

 

[sdk]

Hi,

Your request sets a bit of a problem - the page limit. I use Access 97 Developers Handbook (ISBN: 0782119417; Sybex, Incorporated; 01/01/1997). Unfortunately the size is a little daunting: ~1600 pages. However this is a definitive reference, and does walk through the processes, functions & concepts it illustrates. And you don't have to go vcover to cover to understand (at least, not all the time!).

What I have found most difficult to grasp, in this and any other 'reasonable' standard ref, is the use and application of Data Access Objects (DAOs). However, perservering with them does open lots of doors for improving your application and better undertsanding of how it all works.

This book was recommended to me, and I have seen other recommendations over the net. There is a version available for Access 2000 also.

You might like to look at

http://www.mvps.org/access/resources/books.htm

for some other resources available.

Have fun

 

[LarryDeLaruelle]

Milin:

I have found Beginning Access 97 VBA Programming by Robert Smith and David Sussman, published by Wrox Press, to be a very good text for getting started with VBA. I believe they also have a version for Access 2000.

Page count is just over 600 and it comes with a CD containing sample code and the database used in the text. The format takes the user through the development of the database and, for each exercise, includes the beginning version of the Db as well as the completed exercise.

Hope this helps.
Larry De Laruelle
larry1de@yahoo.com

 

[Garridon]

And I have Visual Basic Answers!, which only runs about 550 pages. It's by Michael Otey.


Linda Adams
Garridon@aol.com
Linda Adams online

http://www.geocities.com/hallona_2000

David Hedison Online

http://www.david-hedison.com

 

[Quehay]

I concur with the above. Here's what I'd go with:

1. QUE Using Access (excellent overall program guide
& good VBA intro)
2. The Wrox Beginning Access VBA (Larry's pick)is a
great intro to VBA and has some very useful routines.
3. The Sybex, Getz, et al (sdk's pick) is essential.
4. MS Access Power Programming, F. Scott Barker, Sams is
another really good book with a thorough treatment of
COM automation and DAO vs. ADO.

 

[ErikZ]

I was trying to look up Sybex's books. All I could find is "Microsoft access for Windows 95" or books for Win2k.

Is there a 98 version?

Later,
ErikZ