Access VBA Events: What Are Events And How Do We Use MS Access VBA Events

Access VBA Events: What Are Events And How Do We Use MS Access VBA Events

Microsoft Access VBA events have been around forever! Well, not forever but since VBA has been (circa 20+ years) and it’s still widely unexplored beyond the basic event triggers one gets to see and know about namely the clicking of a Command Button on a form or when the form itself opens.

Many users and developers have used events in many ways which is not just exclusive to MS Access (Excel is also a very popular application) and to get a feel for how one could use an event, check out this six minute video tutorial which runs through the After Update event to calculate a total from two other field controls in a form…

httpvh://www.youtube.com/watch?v=KFMrSbmsrg4

The video demonstrates how you can create VBA code and attach it to predefined event signatures that each control and object hosts. One could argue however why Continue reading “Access VBA Events: What Are Events And How Do We Use MS Access VBA Events”

Auditing Your Microsoft Access Database: Tools And Data Processing

Auditing Your Microsoft Access Database: Tools And Data Processing

I’ve talked about the importance of auditing your Microsoft Access database before and it amazes me how developers and power users take this not seriously enough and cut corners.

There are two areas that can be considered the action of carryout some sort of audit to your database application which have been mentioned this is the past.

Auditing Your Microsoft Access Database
Auditing Your Microsoft Access Database

However, I found the following article Continue reading “Auditing Your Microsoft Access Database: Tools And Data Processing”

Microsoft Access 2013 Runtime Now Available

Microsoft Access 2013 Runtime Now Available

Over the years (generations from version 95), developers were able to distribute their own custom built Access database applications to users who did not have an Access licence by using the freely available run-time version and now this also includes Microsoft Access 2013.

You can now go and download the Access 2013 Runtime direct from  Microsoft or if you prefer, can also find it here with other Access database free stuff too.

microsoft access 2013 runtime

Just in case English is not your native tongue, it’s now available Continue reading “Microsoft Access 2013 Runtime Now Available”