Learn VBA

[Michael B]

Hi,


what is the best/easiest way to learn VBA?

Thanks

M.

 

[JimS]

If you're using A2000-2003, record a macro or use an Access wizard to create
a button, then convert the macro to vba. Study the vba that's converted, and
begin making subtle changes to it. Try the changes out. Then get a book.
There are hundreds. Used book stores are your best value if you're working
with A2000-2003, as any book referring to A2000 through A2003 will have
similar enough syntax to be accurate for learning purposes. Try
BetterWorld.com used book store, for example.

 

[Douglas J. Steele]

No version of Access has ever had the ability to record a macro. And in all
versions of Access prior to Access 2007, the wizards generate VBA code, not
macros.

You could check the free Access Basics e-book Crystal Long has at
http://www.accessmvp.com/Strive4Peace/Index.htm

You can also check Jeff Conrad's list of resources at
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

 

[JimS]

I'm 0 for 2 today! I used to use the code generated by wizards as the
foundation for more complex command button procedures. I lament A2007's
creation of "embedded macros". Don't see how to convert 'em to vba, either.

Doug, thanks for the correction.