M
Michael B
Hi,
what is the best/easiest way to learn VBA?
Thanks
M.
what is the best/easiest way to learn VBA?
Thanks
M.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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.
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.
D
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
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
J
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.
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.