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

Navigating Form Data

Changing Form Data




Refer to controls


Combobox / drop down list



Working with Access Reports


Magaging data using DAO/ACE

fragments in Code VBA add-in