Microsoft Visual Basic for Access Tutorials

Microsoft Visual Basic for Applications is actually the language that is part 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. One is to furnish individual MDBs with passwords. Although in DAO, you can use the OpenDatabase method to open such a database without getting a password prompt, there is no method to do so prior to Access 2002. The Application.OpenCurrentDatabase method of includes and optional parameter to specify the database password. The second method is to provide a series of usernames and passwords to secure Access itself. The username and password prompt can be avoided in this case by using the Shell command and the GetObject method.
The main problem with using the Shell command to open a secured Access database is it does not register itself in the running object table until it has lost focus once. This means that until it loses focus, it cannot be found with a call to GetObject and automated. The following Visual Basic code demonstrates how to launch a secured Access database and get the running instance of it can be automated. For further details please view our online VBA Microsoft Visual Basic for Access tutorials.

This training course is designed for fast learning and covers all the fundamental points of the application, all cds work on a mac or pc and no application is needed.

The links below are free Microsoft Visual Basic for Access tutorials The entire contents may be purchased either on CD or watched via the Online University

Introduction
 VBA Basics
 Introducing VBA and the Development Environment
 Event Programming 1
 Event Programming 2
 Event Programming 3
 Event Programming 4
 Event Programming 5
 Event Programming 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 I
 MsgBox and Input Box I I
 Validating Using ON_CHANGE
 Validating Using ON_CHANGE
 "Live" Calculations 1
 "Live" Calculations 2
 "Live" Calculations 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

Mulitple Form Applications
Mulitple 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
Adding a Record
Editing a Record
Deleting a Record
Cancel a Change
Moving Around

DAO Practical Applications
DAO Practical Applications
Locating Records 1