Microsoft Visual Basic for Access
Training
Provided by The Virtual Training Company
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.
|
|
||||||||
Microsoft Visual Basic for Access
Introduction
- VBA Basics
- VBA and the Development Environment
- Event Programming pt. 1
- Event Programming pt. 2
- Event Programming pt. 3
- Event Programming pt. 4
- Event Programming pt. 5
- Event Programming pt. 6
- Using Events
- VBA Variables
- Control Structures
Modules
- Intro to Modules
- Creating a Module
- A Sub Routine
- Validate Using a Function
Communicting with the User
- User Interaction
- MsgBox and Input Box pt. 1
- MsgBox and Input Box pt. 2
- Validating Using ON_CHANGE pt. 1
- Validating Using ON_CHANGE pt. 2
- "Live" Calculations pt. 1
- "Live" Calculations pt. 2
- "Live" Calculations pt. 3
- Captions and Status Bar Properties
- The Registry-Writing
- The Registry-Retrieving
Error Trapping and De-Bugging
- Error Trapping and De-Bugging
- De-Bugging
- Programming the On_Error
- In-Line Error Trapping
Multiple Form Applications
- Multiple Form Applications
- Forms Switchboard
- The Forms Collection
- The Dirty Property
- Conditional Opening
The ActiveX-Calendar Control
- The ActiveX-Calendar Control
- Setting Up
- Passing Data
- Writing Generic Code
Looping
- Looping Through Form Controls
- Looping and Tags
- More Looping
Programming GUI Controls
- Programming GUI Controls
- Combo Boxes-Intro
- Combo Boxes-Using
- Check Boxes
Data Access Objects
- Introducing Data Access Objects
- Counting Records
- Using a Select Statemet
- Archiving Records
- Deleting Records
Unbound Forms
- Unbound 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 Applications
- DAO 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
About The Training Provider: The Virtual Training Company
The Virtual Training Company - The Virtual Training Company started in California's Silicon Valley in 1996.
VTC grew quickly over the next three years and relocated first in 1999 to the beautiful town of Winchester, Virginia; and six years later to Stephens City, Virginia.
The company was founded by British born Mark Vernon who started producing CD-based training for Apple software. The format on the CDs - narrated...
