VB programming guides or books

[Bill_De]

I am trying to find a good book/manual on VB programming. I have the Access
Bible but the section on VB does not go into a lot of detail. I would like to
learn more about writing code.
For example I was working on a data base and wanted to update one subform
while in another. I got the answer from someone in the discussion group but
could not find the code for recalculating in the Access bible.

There are so many books on the market and I don't want to keep buy books and
finding out I have the wrong ones.

If anyone knows a good book on learning VB code/programming please advise.

Thank you
Bill_De

 

[Douglas J. Steele]

The ultimate is the Access Developer's Handbook. See
http://www.developershandbook.com/

 

[Bill_De]

Thanks I will give it a shot hopefully I can find it in one of the major book
stores also so I can review it a little. Will also check the web site out.

Bill_D

 

[Bill_De]

HI Doug,
I went to the web site below and took a look at all of the books that they
have to offer.
I have "Access 2003" installed on my machine and am running Windows XP Home
edition.

They listed a few books and sets and I am not sure which one would be the
best for me.

1- VBA Developers Handbook
2- Access 2000 and VB Language Developers set
3- Visual Basic Developers Handbook
4- Access 2000 Developers Handbook set

I should let you know that I know very little about writing VB Code (VBA).
Most of the code I have entered I have gotten from people that have a lot of
experience writing code so I guess I would need something that would start me
out at the basic level.

That is why I am writing for help most books that I have found don't include
some sort of basic level training.

Any help you can give me would be great.

Thanks
Bill_De

 

[Douglas J. Steele]

Any or all of them would be worthwhile. 2 (Access 2000 and VB Language
Developers set) is the most comprehensive of the three, containing both 3
(Visual Basic Developers Handbook) and 4 (Access 2000 Developers Handbook
set), or 3 books in all. As the site says, 1 is essentially a fix of 3, so
there's no overwhelming need for it if you get 2 or 3.

I wouldn't get hung up on the fact that they say Access 2000: little has
changed in VBA between Access 2000, Access 2002 and Access 2003.

 

[Brendan Reynolds]

The Developers Handbook is an indispensable resource for professional
developers, but I would not recommend it as an introduction to Access VBA
programming for beginners. The best introduction for beginners to Access VBA
programming that I have read is 'Beginning Access 97 VBA Programming', by
Robert Smith and David Sussman. There are more recent editions of this book,
for Access 2000 and Access 2002. I have not read those editions, but they
are by the same authors, so I would expect them to be good. There is an
Access 2003 edition, but that is by a different author. I can't comment on
that one. (I'm not saying that it is not good, just that I do not know about
it.)

There was not a great deal that was new in Access 2003, most of what you
will read in an Access 2002 programming book will still be relevant in
Access 2003.