Question Suggestions for learning VBA for Access 2007

[ctpoodle]

Does anyone have any good (inexpensive hopefully) suggestions for learning VBA for Access 2007? I'm looking for classes, online learning, books, etc. I've been working in Access for years but am a total VBA novice. Thank you!

 

[Beetle]

As far as online learning, you might have a look at this link, or if you Google it you will find many others as well. As far as books go, there are many available, but it's hard to make book recommendations because of the different styles in which books are written. My recommendation would be to go to your local bookstore (if you don't live in a rural area) and peruse a few of them to see which of them are written in a style that you like. If that's not an option you can perhaps choose a few on Amazon and use the chapter previews to get a feel for how they're written.

 

[speedball]

For online tutorials, I find Lynda.com to be very useful. There is a course called "Up and Running with VBA in Access", which might suit you, though I've not watched this particular course myself.

I used 'Access VBA Programming for Dummies' when I started to learn VBA for Access 2003. I assume there is a 2007 or 2010 equivalent. It's quite an easy book to just go through from start to finish before you even open VBA and it will give you an overview of what's involved.

 

[jdraw]

You might find info on youtube

here are a couple of examples
https://www.youtube.com/watch?v=G9pqmd2PSYk
https://www.youtube.com/watch?v=WZFBHQWZpQo

 

[ChrisO]

The <F1> key is a good place to start. (That actually depends a little on Access version.)

It might seem strange but a few years ago someone said to me that they had been using VBA for three years and did not know about the <F1> key. I think that strange because for the first six years of VBA I didn’t use anything else.

It is surprising how many questions posted on this and other sites could have been answered just by using the built in help.

Another thing I would add here. A lot of what we may read on the internet is simply recycled internet information. The recycling goes round and round, site to site, gaining bulk, but few people seem to question things. By all means read everything you can but, by the same token, question everything you can.

An example of question things is in one of links in post #4. In the first screen shot of writing code there is no Option Explicit and the Form name is hard coded rather than using Me.

If you see something interesting, test it. Create a new database and write the code. If it doesn’t work then fix that small part. If it does work then make it work better. If you still think it looks like junk then ask a question about how to write it better.

Read, write, test and question.

Chris.

 

[jdraw]

I agree totally with ChrisO that things found on the internet should be questioned. There are many examples, and as he points out, not all follow a Best Practices approach.
Yes you should use the Options Explicit and yes you should use a Naming Convention that uses only alphanumeric and underscore, but if you're looking for one best site for everything, you'll be looking a long time.

There are many sites with great, well referenced examples (and there are many that most of us have never been to), so search, review, question, test and learn.

Sites with good info (in my view)
http://www.fontstuff.com/access/index.htm
http://allenbrowne.com/tips.html
http://www.datapigtechnologies.com/AccessMain.htm
http://www.accessmvp.com/strive4peace/
http://www.datawright.com.au/access_resources/access_tips.htm#tip_create_event
http://www.rogersaccesslibrary.com/forum/topic238.html
http://www.access-programmers.co.uk/forums/forumdisplay.php?f=63
http://www.access-programmers.co.uk/forums/forumdisplay.php?f=64

As mentioned above, there are many, many more.
Google these for more
techonthenet, w3schools, utteraccess