Tips and code for Access VBA available on the web

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 in 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




Refer to controls


Combobox / drop down list



Working with Access Reports


Managing data using DAO/ACE

fragments in Code VBA add-in