VBA coding

[catt]

I love working with Access. I have migrated from Access2 to Access97 and now I work with Access2000. I have no problems with queries, forms, macros, but I would like to move to VBA. I have several books on VB, and the coding is fine, but not enough to help me with VBA.

What I find very confusing is the names for the objects. I don't seem to be able to grasp the concept of the names of the objects. I am familiar with C, Cobol and SQL, so it's not the programming that is getting me confused. Visual Basic seems like any other programming language, but VBA confuses me.

Is there an easy way to learn VBA, that is easy and concise. Local colleges offer VB classes but not VBA.


HELP!!!!


Thanks.

 

[ListO]

There's probably a half-dozen books on that in my local bookstores, though I haven't found any particular one I'd suggest.

You could look at the code behind the Northwinds database, and several bulleton boards have sample databases with good code to study.

And then there's the good old jump on in and try something. It's always more mysterious before you do it.

One great resource is this forum, but instead of posting a lot of questions that have already been answered over and over, use the search capabilities and see what other people have already posted on the subject!


Good luck.

 

[axa]

hi catt,

when it comes to understanding common naming convetions used in access vba, the following link may help:
http://msdn.microsoft.com/library/en-us/dnaccgen/html/msdn_20naming.asp

the article above gives a good guide to common naming practices used in the access vba world and vb in general. most people follow this style of naming to some degree (whether intentionally or not!)

hope that helps some.

axa