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.
I am currently revamping this site, and transferring all the VBA coding related tips, questions and answer links to this page, from this page:
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 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.
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
This tip will explain how to export data into a table that is within a Microsoft Word document using VBA code.