Learning to code in VBA

[Flightdisc]

Hello all,

I would like to learn how to code in VBA specifically for coding in Access.
I have seen many of the examples used throughout the Microsoft forums and I
am amazed at what the scripting can do to improve the functionality of a
database.

Can anyone offer some thoughts on what approach I should take to learn how
to code in VBA.

 

[Tony Toews [MVP]]

I would like to learn how to code in VBA specifically for coding in Access.
I have seen many of the examples used throughout the Microsoft forums and I
am amazed at what the scripting can do to improve the functionality of a
database.

Can anyone offer some thoughts on what approach I should take to learn how
to code in VBA.

Look for an Access <insert your version> Programming for Dummies book.
I have the A97 book and it taught me a few useful things that I hadn't
realized by then. Most of the book of course I could've written.
<smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Mike Painter]

Hello all,

I would like to learn how to code in VBA specifically for coding in
Access. I have seen many of the examples used throughout the
Microsoft forums and I am amazed at what the scripting can do to
improve the functionality of a database.

Can anyone offer some thoughts on what approach I should take to
learn how to code in VBA.

Go to a bookstore, grab some coffee and sit down with a few of them.
Read them as you would a novel.
You should find one that suits your style and programming knowledge.

More is better and eBay is a good place to pick up such books cheap,
especially if they are a few versions behind. You might not get teh bells
and whistles of a newer version but the basics are the same.

Asking here about something you want to try is also a good idea.
Some coding problems seem simple if you have never done them before.

 

[Flightdisc]

Thanks to both of you for your input on this. I'll follow suggestions
offered here and see what's out there. Again, thanks a million for your
replies to my post.

-FD