Books & Videos

Table of Contents

Chapter: Introducing VBA For Access

Can I Really Become A Programmer

02m 52s

About The Author

01m 30s

Using The Working Files

02m 0s

Initial Setup Of The Sample Databases Provided

02m 45s

Chapter: Moving From A Database To An Application

What Is VBA

03m 20s

Where Is The VBA

04m 38s

The VBA Editor Quick Tour

02m 34s

The Editor - Explorer And Properties Windows

02m 50s

The Editor - The Debug Window

02m 45s

Macros Or VBA - Convert Your Macro To Code

03m 19s

Chapter: Programming In VBA

Getting Started With A Standard Module

02m 11s

Creating A Procedure

02m 55s

Adding Comments To Your Code

02m 11s

VBA Data Types

02m 38s

Declaring Parameters For Use In Procedures

04m 30s

How To Declare Variables And Constants

05m 9s

Creating And Assigning Array Values

04m 21s

The Scope And Lifetime Of Variables

03m 33s

Standard Naming Conventions For Variables

03m 24s

Handling Multiple Line Commands

03m 44s

The Very Useful Keyword - ME

02m 45s

Chapter: Repeating VBA Code

Do Loop

04m 34s

While Wend

01m 54s

For Next

04m 47s

If Else End If

07m 2s

The Very Flexible Select Case Statement

05m 17s

Chapter: Working With Access Objects

The Access Object Model

07m 23s

Changing The Value Of Object Properties

04m 14s

Access Special Object DoCmd

03m 52s

Class Modules And Class Procedures

04m 35s

Enable And Disable Controls

05m 41s

Hide Or Show Form Controls

05m 47s

Lock Unlock Controls

02m 52s

Form Events To Trigger Procedures

05m 48s

Setting Color Properties

07m 19s

Defining Your Own Custom Colours

08m 9s

Defining Font Properties Through Your Code

05m 46s

With End With To Shorten Code Writing

02m 48s

Assigning Values To Data Fields On A Form

06m 44s

Opening A Form

05m 29s

Open Form And Display Filtered Dataset

06m 41s

Closing Any Open Form

06m 0s

Chapter: Data Manipulation

A Very Quick SQL Tour

03m 54s

Running An Action Query As Code

04m 50s

Stop Warnings On Action Queries When Run In VBA

04m 12s

Building And Storing SQL In Variables

05m 39s

Changing The Sql That Populates A List Or Combo Box

04m 28s

Create A New Table

03m 56s

Deleting (And Closing) A Table

04m 47s

Adding Data To Tables Through Code

07m 38s

The Recordset Explained

07m 29s

How To Reference Fields In A Recordset

02m 13s

Navigating Through The Rows Of A Recordset

02m 41s

Closing Off A Recordset And ADODB Connection

02m 14s

The Recordset In Action

13m 5s

DCOUNT (Great Function)

06m 10s

Chapter: Interacting With The User

Getting Started With The MSGBOX

07m 13s

Customizing The MSGBOX

06m 12s

Reacting To The User Response In A MSGBOX

06m 4s

Creating A Dialog Box

04m 29s

Using A Dialog To Give Choices To Users

07m 46s

Combo Box Dynamic List Building

06m 1s

Excluding Values From The Combo Box List

03m 7s

Using The Combo Box Selected Value

04m 42s

Detecting The Right Mouse Click

07m 20s

Chapter: Combo And ListBox Specials

Combo Box And ListBox Properties

04m 5s

Accessing And Setting Combo And Field List Properties

09m 12s

Accessing Combo Box Fields From A Different Form

10m 45s

List Box Search Application

04m 26s

Chapter: Functions

What Is A Function

02m 21s

Creating A Custom Function

04m 17s

A Proper ProperCase Function

06m 53s

Chapter: Testing, Error Handling And Debugging

The Three Types Of Errors

04m 48s

Handling Logical Errors With Debug Print

05m 39s

Handling Logical Errors With Breakpoints

05m 46s

Creating Your Own Runtime Error Handler

06m 7s

Specific Error Messages For Specific Errors

06m 51s

Chapter: And Finally

Locking The VBA From Prying Eyes

02m 57s

So What's Next

03m 13s