Where can i Learn VBA

[WilsonDC]

I have a small amount of understanding of Macros but keep running into this VBA terminology stuff. Only thing i have gotten is you gotta use DIM alot. lol I just wanted to know where is a good place or way to get started learning this. A lot of my answers to problems have all been in VBA. Thanks for any suggestions

 

[Beetle]

Here's a Introduction To Access VBA web page. Or you can more than likely find several books on the subject at your local bookstore / library. Having at least some level of knowledge in VBA will greatly expand your abilities to accomplish what you want in Access.

 

[Isskint]

I 'learnt' VBA on the go - trial and error. I started with Excel as you can record a macro then look at the VBA to see how the actions you have just macro'd translate into VBA. There are many exceptions to this process but it does give you an understanding. VBA in Access (or word or Outlook etc) is basically the same animal with different Methods, Properties etc.
There are plenty of good websites out there. One i used a lot early on was Martin Green's www.fontstuff.com. He has a lot of good examples and a VBA course (free and paid versions).

Also you have the Code Repository and Modules & Practice on this forum. Look at samples, see what they do then break down the code and figure out HOW it is done.

 

[Pat Hartman]

You can start by making a copy of your database and using the conversion feature to convert all the macros to VBA. They don't generate "good" code but if you knew what the macro did, you'll know what the VBA does and so it helps you to learn by example. There are lots of books out there. One of my favorites is the Access Cookbook published by O'Reilly. There are several versions but the newest may be for A2003. The second edition was published in 2004. Unless you find a newer one, that will get you started. Besides, you can buy a used copy for under $9. VBA hasn't changed except for the addition of a few new functions.

 

[ruthiet77]

I have a web based reports page created from an html that extracts data from Maximo into Access. The Access queries are in 2003. Everything works fine in Windows XP. I have been upgraded to Windows 7 and now the reports do not execute. I get an endless hourglass. I don't know anything about VBA. Where can I get some support to figure out the difference in VBA of Windows 7 vs Windows XP? Also, Access 2010 came with the new system. I am unable to establish an ODBC link, although the driver works for Access 2007. The reports page is very popular with my managers and it is imperative that I solve this issue. I will probably need some coaching. Please help!!

 

[gemma-the-husky]

VBA Developers Handbook (Getz and Gilbert)

{more of a mighty tome than a handbook}

try and get a cheap s/h copy from you know where. old version is fine.