VBA Codes

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.