t_ac_vba.gif (6511 bytes)

   

Tales

t_menu.gif (1730 bytes)

Home

Contact Us

Overview Company

Home

Contact Us
    
This one or two day class presents VBA code useful in developing efficient and flexible Microsoft Database solutions. The instructional time needed depends on the experience of the students with Access and with programming concepts. The students receive a copy of the code, heavily commented, and a functioning database containing the code.

Some of the items listed below are simple and can be covered quiclky. Others require more time to be covered.

As the list probably suggests, the one day version is for persons already familiar with programming who need to be brought up to speed with VBA and Access. The two day version is for those less familiar with programming and Access.

The list below is one of the tables of contents from the manual, minus the page numbers.

     
Course Outline
 

Use Of The Form's New Record Property To Add And Select Records

Use Of The Form's Allow Additions Property To Control Navigation

Synergy Among Allow Additions, New Record, And Caption

Undo Property (Vb's Esc Button)

Docmd.GotoRecord Uses

Docmd.RunCommand Uses

Importance Of Requerying A Combo Box After Updating Records

Using Vba To Open A Query, Retrieve Data, And Update A Primary Key.

Using Code To Delete A Record

Validating Data On A Main Form While Entering A Subform.

Managing The On Not In List Property Of A Combo Box

Transferring Data From The Columns Of A Combo Box To Controls On A Form.

Filling Unbound Controls On A Form From A Recordset Opened Using VBA

Opening A Query Using Code To Retrieve Data For A Primary Key

Using The Before Update Event To Validate Data

How To Delete An Item In One Table And Let Cascade Delete Remove Items In A Related Table.

Validating Data On A Main Form Just Before Activating A Subform And Aborting The Activation If Necessary.

Using The Open Args Property Of A Form To Determine How It Opens.

Closing A Form Using A Button's Caption Property To Direct Code Flow.

Parsing Text That May Be A Name.

Using The Recordsetclone And Bookmark Properties To Find A Record.

Using A Combo Box To Define A Search Criteria For A Vb Recordset .

Using Vba To Open A Recordset And Delete A Record Selected By A Form.

Using The Return Value Of A Function To Control Program Flow.

Using The Return Value Of A Function To Control Program Flow.

A Function That Returns A Value To Direct Program Flow.

Using Code To Print Selected Details In Color.

Code To Hide\Display Sections On A Report

Changing The Same Report From A Detailed To A Summary Report

Controlling A Report From An Option Group On A Form.

Using Code To Pass A Form To A Global Procedure.

Using A Combo Box To Define The Value Of A Argument Passed To A Global Procedure.

With…End With

Do Unitl … Loop

If … Then … Elseif… Else

Looping Through A Recordset To Alter Selective Records.

Looping Through Recordsets Based On Internal Tables

Looping Through Recordsets Based On Linked Tables

Looping Through Recordsets Based On Linked Tables

Using Seek

Using Find First And No Match

Using Code To Cancel An Opening Form

How To Export Data To Excel And Open It

If..Then Branching Controlled By An Option Group

Defining Module-Wide Variables As A Form Opens.

Command Buttons Activate Code Attached To Their On Click Event

A Form Procedure Calls A Global Procedure

A Form Procedure Passes Arguments To A Global Procedure

A Command Button's On Click Event Terminates Access

A User Defined Data Type.

A Global Error Trap

A Global Procedure For Manipulating The Appearance Of A Form

Looping Through Any Form's Controls And Making Selective Changes

A Global Procedure To Open And Close Forms.

 

Tales Training Overview
t_menu.gif (1730 bytes) CompanyS
Home Home
Contact Us Contact Us