Computer Learning Zone CLZ Access Excel Word Windows

Not only do we live among the stars, the stars live within us.

-Neil deGrasse Tyson
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
VB vs. VBA
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   14 years ago

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.

Upload Images   Link  
Chris Bezant 
14 years ago
I rarely allow updating in my continuous forms in Access. I usually use the continuous form to select a record for processing and respond to a click that brings up a detail form for editing the record. In VB I did the same kind of thing by using a listbox containing several columns and responded to the click so I understand the listbox solution. Read More...
Add a Reply
Upload Images   Link  
Richard Rost 
14 years ago
Chris, creating a continuous form in VB is going to be really difficult. I've never actually tried to do this myself. In fact, to be honest, whenever I'm working with a VB program and need to do any kind of database connectivity aside from the most BASIC read/writes, I almost always try to use (or talk the client into) a Microsoft Access solution. You could try using a DBGrid or ListView control to accomplish what you want, but they're not going to give you the level of control that Access would. I'll cover these two controls in a future VB lesson.
Add a Reply
Upload Images   Link  
Chris Bezant 
14 years ago
I'd like to ask a similar question but don't know where to ask it.
Having taken all of your Access courses I have been quite taken with the VB ones as well. I would like to interface between VB and an Access database but my biggest problem is not understanding how to produce a continuous form. Can you help please, Richard??? Read More...
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: vb vba access   PermaLink