Database Code

Opening a Report

Writing Code in a Report

Public Variables

PopUp Forms (Dialog Boxes)

MultiSelect List Boxes

Select All Items in List Box

Clear List Box Selections

For…Each…Next

In(), Len(), Left() Functions

Filter Dialog Box

      Make a Dialog Box Generic

      The Filter Properties

      The Tag Property

      For…To…Next

      Chr() Function

      Building String Where Condition

Changing a Group of Controls

      Using Toggle Buttons

      Setting Control Properties

      With…End With

      The Controls Collection

      For…Each…Next

Running a Query in Code

Running a SQL Statement in Code

Convent Macros to Code

About Bound Columns (Combo/List)

More about the Module Window

More About MsgBox()

DAO & Custom Functions

Do…Loop

DAO Topics

      Opening a Recordset

      Recordset Types

      Using Properties & Methods

      Adding Values to a Combo Box

      Moving through a Recordset

      Evaluating Each Record

      Transaction Tracking

      Adding, Editing, Deleting Records

      Finding Records

      Printing to Immediate Window

      Opening Two Recordsets

      Copy Data Between Recordsets

      Creating a Recordset Subset

      Recordset Clones

      Bookmarks

Custom Functions

      Creating a Simple Function

      Using a Function in the Database

      Data Types

      Adding Parameters to Functions

      Optional Parameters

      Using in Place of "nested IIFs"

Stepping Through a Procedure

      Debug Toolbar

      Using the Debug/Locals Window

      Setting a Breakpoint

      Executing Commands

Calendar Control (Active X)

Progress Bar (Active X)

Understanding References