Dick
OK - if you know where you are coming from, it's a lot easier
I see two issues in VBA programming
1. Understanding the mechanics of producing code. Understanding the various data types, and the functions and procedures available. Understanding the logic of building a sequential programming, and the importance of using modular code - small encapsulated procedures, using arguments and parameters, and limiting the scope of variables. I learnt to programme with Pascal - and the disciplines that builds in are very sound. C and it's derivatives are similar
2. Understanding event-driven programming. Unlike a monolithic sequential code, where the programmer knows exactyl what path the process will follow, a windows-app is more random. Users can click on any object, or open any form, at any point - the programme becomes more a series of reactions to each of these click or events, but in a controlled way - so that events don't interfere with each other. This is sometimes hard to accomplish, as you cannot be 100% certain what your users will do.
Recommended Book:
The best book by far I ever found, and the most helpful resource I ever used is the Access Cookbook (O'Reilly). It isn't a primer, more a series of solutions including VBA, to many real world problems. My copy of this is regularly used, and well-worn, unlike most of my other books.
