Tips and code reference for programming in MS Access VBA

The links on this page direct to the best available sources found on the web, including Microsoft Office developer documentation, Allen Browne and The Access Web. When possible solutions have been included as fragments in the fragments library included in the Code VBA knowledge and productivity add-in which can be downloaded here. In selecting the pages to link to I made a personal judgment on what I consider useful. The links have been grouped in themes which speak for themselves. Whenever a link title itself is not sufficiently clear I've added a short explanation on what to expect.

Working with Access Forms using VBA

Opening and closing forms

  • Open an Access Form - using the DoCmd.OpenForm arguments: view, datamode, filtername, where condition and openargs.
  • Close an Access Form - save record before closing form, Ask the user for confirmation before closing the form, close all open forms, save changes to the Form object
  • Keep something open - after closing a form, probably a kind of 'Switchboard' form.

Navigating Form Data

Changing Form Data

Other

Events

Controls

Refer to controls

Textbox

Combobox / drop down list

Subform

Section

Working with Access Reports

Fields

Magaging data using DAO/ACE

fragments in Code VBA add-in