Q: I am not a programmer by nature. A while ago, I purchased VB 101. Basic stuff. My goal is to become "decent" with VBA. How different is it from straight VB? Will your new VB courses take me in that direction? - Lou

A: Lou, VBA is a close cousin of VB.

VB is a self-contained programming environment used for building standalone programs.

VBA is used with other programs (Visual Basic FOR APPLICATIONS) like Word, Excel, and Access.

My VB courses will teach you the VB language, plus specific controls for use with building programs. A good solid foundation in VB will help you to learn VBA, yes... but there is also a lot of extraneous material you might never need (as there is with any class you take).

If you want to learn VBA, you should study the VBA specific to the programs you want to work with. For example, I cover a LOT of VBA in my Microsoft Access 300-series of classes. It's VBA that's specific to Access.

I will also be covering VBA specific to Word, Excel, and even Outlook in those classes.

Hope that answers your question.

Where is all the action Upload Images   Link   Ron Oates  10 years ago I am perplexed at why no-one has commented since I did a year and a half ago, and that was the first one since two years previous??? Reply from Richard Rost: It's an old thread on an old topic. Perhaps try posting something new in the Access Forum. Read More... Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

correct courses for me Upload Images   Link   Turnditch  12 years ago I want to design an accounting and inventory control program for my small business.  I am fairly good at excel and have been using it, but I want more.  I have taken your first few courses in access but it does not seem to be right for my needs.  I have just taken the first three courses in VB.  What do you suggest? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

VB Upload Images   Link   Ron Oates  12 years ago I write a few programs in VB6 and use access as a database but VB6 only talks to Access 97 and all of our PCs at work have Access 2007. what is the best way to get around this when I have to make changes to tables etc. Read More... Reply from Richard Rost: Ron, I'm not familiar with any method of connecting to an ACCDB file (Access 2007) from VB6. I've never tried it. I would suggest, if possible, save your Access databases in the Access 2000 file format (which will still work with AC2007 front-end databases). If that's not possible, try a Google search and see if there is a DLL or other code out there that someone has developed for this. I'm sure Microsoft wants you to upgrade your version of VB though. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Show Older Comments...
View in Table Format