VTC Microsoft Visual Basic for Access
9 hrs / 70 lessons
http://www.vtc.com/products/vb-access.htm
Introduction
VBA Basics (00:47)
VBA and the Development Environment (12:04)
Event Programming pt. 1 (02:41)
Event Programming pt. 2 (01:49)
Event Programming pt. 3 (01:26)
Event Programming pt. 4 (02:10)
Event Programming pt. 5 (01:42)
Event Programming pt. 6 (01:45)
Using Events (07:55)
VBA Variables (15:31)
Control Structures (10:52)
Modules
Intro to Modules (00:32)
Creating a Module (07:40)
A Sub Routine (07:21)
Validate Using a Function (10:46)
Communicting with the User
User Interaction (01:31)
MsgBox and Input Box pt. 1 (03:50)
MsgBox and Input Box pt. 2 (01:37)
Validating Using ON_CHANGE pt. 1 (03:05)
Validating Using ON_CHANGE pt. 2 (03:21)
"Live" Calculations pt. 1 (01:56)
"Live" Calculations pt. 2 (01:55)
"Live" Calculations pt. 3 (03:11)
Captions and Status Bar Properties (16:00)
The Registry-Writing (09:09)
The Registry-Retrieving (07:26)
Error Trapping and De-Bugging
Error Trapping and De-Bugging (01:26)
De-Bugging (10:01)
Programming the On_Error (09:47)
In-Line Error Trapping (16:42)
Multiple Form Applications
Multiple Form Applications (01:11)
Forms Switchboard (14:34)
The Forms Collection (09:19)
The Dirty Property (08:31)
Conditional Opening (08:45)
The ActiveX-Calendar Control
The ActiveX-Calendar Control (01:02)
Setting Up (07:40)
Passing Data (11:14)
Writing Generic Code (08:55)
Looping
Looping Through Form Controls (00:46)
Looping and Tags (11:26)
More Looping (04:48)
Programming GUI Controls
Programming GUI Controls (00:25)
Combo Boxes-Intro (04:22)
Combo Boxes-Using (08:28)
Check Boxes (12:42)
Data Access Objects
Introducing Data Access Objects (01:32)
Counting Records (08:32)
Using a Select Statemet (05:23)
Archiving Records (09:42)
Deleting Records (02:03)
Unbound Forms
Unbound Forms (02:23)
Front End Preparation (09:08)
Object Scope (08:08)
Buttons pt. 1 (07:27)
Buttons pt. 2 (08:19)
Adding a Record (14:37)
Editing a Record (08:28)
Deleting a Record (07:10)
Cancel a Change (02:56)
Moving Around (16:26)
DAO Practical Applications
DAO Practical Applications (01:37)
Locating Records pt. 1 (09:10)
Locating Records pt. 2 (06:32)
Locating Records pt. 3 (10:08)
Locating Records pt. 4 (08:21)
Tracking Used Records pt. 1 (14:03)
Tracking Used Records pt. 2 (03:22)
Tracking Used Records pt. 3 (12:32)
Tracking Used Records pt. 4 (07:58)
Code:
http://rapidshare.com/files/12387813/vbaccess.part1.rar
http://rapidshare.com/files/12390563/vbaccess.part2.rar
http://rapidshare.com/files/12391470/vbaccess.part3.rar