You're welcome! Glad you got it going.
The two VBA references I've spent the most time in are:
"Access 2000 Developer's Handbook", by Getz, Litwin and Gilbert (2002 ed. available)
"VBA Developer's Handbook", by Getz and Gilbert
The first is Access specific and should be hit first. It covers Access topics not covered by the latter, like Access SQL and ADO/DAO. The latter is about the "universal" VBA language, wherever it shows up, and goes into greater detail on generic language features like string manipulation, class creation, searching and sorting, file I/O, etc. There's defintiely overlap.
For the sake of mentioning it, Access development is done using VBA (Visual Basic for Applications), not VB
(strictly speaking) which is the stand-alone programming system that ships with Visual Studio. VBA has the same core components as VB
, but lacks the forms engine and compiler (hence, no stand-alone components creation). The language engines of the two are equally powerful in most respects. Its just that VBA can only live as a hosted component in some other COM-based application (like Access).
Enjoy the tomes! :)