I have read chapter 22 “Understanding Visual Basic Fundamentals” in Microsoft Office Access 2003 inside out by John L. Viescas and Access 2007 VBA Programming for Dummies. Most of which seems to make sense. But it is still too unfamiliar and remote. I’d like some simpler practical examples to work through of a subs and functions on their own and interacting together within a module such as a form. I can’t seem to get some of the basic concepts in my head. I suspect that I need to unlearn ways I have learnt to do things with other database systems. Does anyone have any simple examples they can either point me at or send to me?
Many thanks
Ro

I don't know if this will help, but this is where I usually send people who want to learn:
http://www.functionx.com/vbaccess/index.htm

Many thanks for this I will look at this tomorrow. I keep reading stuff, and can't help think that by now I should be able (or have the confidence) to do the simplest of code but I still don't know what I don't know.

Thanks again.

A lot of how I learned is to find samples and just look at how things are done. Also, I think the tutorials on FunctionX that I gave you the link for will help you get over that hump. I do believe that they give samples that you can work through yourself with their guidance and explanations.

I think one good way to learn (in addition not instead of) is to try and do things that require VBA. For me, that was originally for Accesss to Word bookmarks as well as some things while Word was opened.

There is nothing like actually doing it. You will also be suprised how far doing one thing takes you, you down all sorts of roads. Some months ago it became necessary for me to be able tp replace batch files I used for general file/folder management. I got to see the sun rise several times while on the keyboard and mouse but I can tell you I learnt a lot more about VBA in that exercise than just file management.

In short:

Read and Do

Fitting in with the and Do is to look at threads that have been started and see if you can solve the problem your self. I am doing some of that moment with queries because I am very poor with SQL.