VBA Codes

This page on Microsoft Access VBA Codes, will in the future consist of lots of tips, questions/answers about VBA Codes and the use of them in Microsoft Access.

If you wish to know the basics on how to create code, then click on the link below.

Click Here to Learn VBA


Simplifying too many nested IIFs by using code

If you have TOO Many nested IIFs then click here

If you have two many nested IIFs, i.e. more than 7 or if it is just getting too messy, then a bit of code maybe necessary, to keep everything succinct, this tip will step you through how to achieve this in a query.

Form Events

Form Events

This tip will give you an overview of all the form events that are available to you when you open a form. An event is where you add code or a Macro to 'do something' with your database.

Export Data to Microsoft Word from Microsoft Access

Export Data to Word

This tip will explain how to export data into a table that is within a Microsoft Word document using VBA code.


Finished with VBA codes, then Click Here to return to Simply Access Home Page


Share this page: