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 I suggest you purchase my VBA Tutorial. This does not only include how to create a VBA code in Microsoft Access, but will step you through the entire process of building your first code in MS Access to becoming proficient in MS Access VBA.

Click Here to Learn VBA

I am currently revamping this site, and transferring all the VBA coding related tips, questions and answer links to this page, from this page:

Simply Access Tips Index

So if you are sure there should be something here that isn't, check out the Index page above, or contact me on my 'Contact Page' to put forward your suggestion and I will do my best to include it.

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