The databasedev and functionx sites were particularly helpful when I was making the move from VB6 to Access/VBA, and Crystal Long's MVP site continues to be useful, after 12 years of working in Access!
But you need to be aware of a couple of things:
- While VB6 and Access VBA are both derived from a common ancestor (QuickBasic4.5), they are not the same language! Functions and Properties in one language are absent from the other language! And even more confusing, Functions and Properties present in both languages do not necessarily do the same thing and do not necessarily utilize the same syntax!
- And more importantly, to me, you're proposing to use a Database development program to develop apps that are not Databases! One of the most important factors in accomplishing a task, successfully, is to select the appropriate tool for the job! And from your original post, and well as my own prior experience, VB6 sounds like a much better fit for this project than MS Access does!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007