Microsoft Visual Basic for Access is actually the language that is part of Microsoft applications such as Word, Excel, and PowerPoint. In this Virtual Training Company tutorial, author Mike Haines explains VBA in the context of Access. He teaches you the concept of event programming, code control structures, variables and constants, and much more. Start becoming familiar with VBA now by clicking one of the links below.
IntroductionVBA BasicsVBA and the Development EnvironmentEvent Programming pt. 1Event Programming pt. 2Event Programming pt. 3Event Programming pt. 4Event Programming pt. 5Event Programming pt. 6Using EventsVBA VariablesControl StructuresModulesIntro to ModulesCreating a ModuleA Sub RoutineValidate Using a FunctionCommunicting with the UserUser InteractionMsgBox and Input Box pt. 1MsgBox and Input Box pt. 2Validating Using ON_CHANGE pt. 1Validating Using ON_CHANGE pt. 2&'Live&' Calculations pt. 1&'Live&' Calculations pt. 2&'Live&' Calculations pt. 3Captions and Status Bar PropertiesThe Registry-WritingThe Registry-RetrievingError Trapping and De-BuggingError Trapping and De-Bugging
De-Bugging
Programming the On_Error
In-Line Error Trapping
Multiple Form ApplicationsMultiple Form Applications
Forms Switchboard
The Forms Collection
The Dirty Property
Conditional Opening
The ActiveX-Calendar ControlThe ActiveX-Calendar Control
Setting Up
Passing Data
Writing Generic Code
LoopingLooping Through Form Controls
Looping and Tags
More Looping
Programming GUI ControlsProgramming GUI Controls
Combo Boxes-Intro
Combo Boxes-Using
Check Boxes
Data Access ObjectsIntroducing Data Access Objects
Counting Records
Using a Select Statemet
Archiving Records
Deleting Records
Unbound FormsUnbound Forms
Front End Preparation
Object Scope
Buttons pt. 1
Buttons pt. 2
Adding a Record
Editing a Record
Deleting a Record
Cancel a Change
Moving Around
DAO Practical ApplicationsDAO Practical Applications
Locating Records pt. 1
Locating Records pt. 2
Locating Records pt. 3
Locating Records pt. 4
Tracking Used Records pt. 1
Tracking Used Records pt. 2
Tracking Used Records pt. 3
Tracking Used Records pt. 4
Click here to find out more about the Microsoft Visual Basic for Access Training CD