VBA jump start

[AccessMan]

I have had trouble getting familiar enough with VBA to take advantage of its
vast potential. I am an experienced programmer, but for some reason I am
finding it difficult to get to the point where I can easily figure out how to
do something or even to research how to do something. Has anybody else had a
similar experience? I'd love some advice. Does anybody know of a good
resource (web site, book) I can tap into that would be helpful? The help
available through Access itself is too specific to individual commands, etc.

Thanks!

 

[Albert D. Kallal]

Ok, you need some examples.

I *excellent* place of examples (organized by forms, reports, modules) is
here:

http://www.mvps.org/access/

The above has a code example for virtually just about any task your ever do
in ms-access.

Also, keep in mind that the code syntax in ms-access is the SAME as vb6. The
difference between ms-access and vb6 is the object model. (ms-access is
considerably MORE complex then vb6 in that regards).

if the above access reference is not quite the cup of tea, then check out
the books suggestions from that above link...

 

[Thomas Duer]

I have found the books written by Ken Getz and Mike Gilbert to be some of the
best reference books on VBA. They have a three book set dealing with VBA and
Access that was packed full of helpful techniques. Amazon has VBA
Developer's Handbook, 2nd Edition (Paperback) by Ken Getz (Author), Mike
Gilbert (Author) listed for $32.99
I have their complete set as reference books next to my PC at home where I
do most of my development.