Best book from which to learn VBA?

[Guest]

I'm looking for a book that can help me learn how to program VBA. Can anyone
recommend a good book for someone who doesn't code for a living (just an
added benefit to my job) and is looking for a book that painstakingly
explains the syntax of commands, variables, objects, etc? In short, I'm
tired of asking for fish and am ready to learn to fish. Any suggestions are
appreciated.

 

[SirPoonga]

A class book. Now, I programmed in VB before I learned Access so it
wasn't that hard. However, I have found the best way to learn anything
computer related, especially programming, is to find a class book. A
class book has alot of examples to work off of and is designed to
teach.

I don't have the books with me, when I get home I will see if I rmember
to look them up. I used a 3 level book system created by a company in
Edina, MN that is a certified Microsoft Partner.

 

[George Nicholson]

I have a personal soft spot for Microsoft Press' "Learn
(YourOfficeAppHere) Programming Step-By-Step" series as a quick and dirty
introduction to the object model for your app, how to get around the VB
Editor, how to use the ObjectBrowser, etc. That's how I started (with
Excel) in a get-your-feet-wet, learn-by-doing approach. Not a lot of depth,
but great for the real basics (including how to look up syntax).

After that, (or alternatively) take a look at:

Better as a tutorial than a reference:
(even though it is for 2000, these basics haven't changed much for XP/2002
or 2003):
Microsoft Access 2000: Building Applications with Forms and Reports
http://msdn.microsoft.com/library/en-us/bapp2000/html/acbatitle.asp

Better as a reference than a tutorial:
Microsoft Access 2003 (VBA) Language Reference
http://msdn.microsoft.com/office/un...ary/en-us/vbaac11/html/Welcome_HV01132058.asp

Once you've reviewed that much, you'll have a better idea what to look for
in all the other resource material that is available, assuming you want to
go farther. One gold standard is Getz, Litwin, et al, "Access Developer's
Handbook", Sybex. But that's an end point, you don't want to start there.

HTH,

 

[M.L. Sco Scofield]

I like the Wrox books.

Beginning Access 2002 VBA (Programmer to Programmer) - (And 2000 and 97) -
By Susman, et al. - I've recommended this book for years

Beginning Access 2003 VBA (Programmer to Programmer) - By Gosnell - Despite
the title, it is a complete rewrite from a different author. Although it's a
good book, I personally don't like it as much as the Susman book which is
100% applicable to 2003 if you can still find it.

Access 2003 VBA Programmer's Reference (Programmer to Programmer) - By
Cardoza, et al. - Although by yet another author and titled as a reference,
I think this is more like the original Susman books.

If you'd like to come to Denver, I'll be holding an Access VBA intro class
on January 26, 27, and 28. I have people fly in from all over the country to
take my Access classes. This time of year, they frequently make it a dual
purpose trip and spend a couple of days up in the mountains skiing. If
you're interested, see my website. There is a description of all of my
classes and a schedule.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com