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…
Microsoft Access Security: How To Login Into Your Access Database
With the release of Microsoft Access 2007 introducing a new file format (ACCDB), the Microsoft Access security completely changed. In fact, it dropped the MDWworkgroup security utility altogether in favour of trusted locations and/or using SharePoint.
However, I wanted to have the ability to control my own collection of objects within my Access database and not rely on either a third party tool or online service but instead keeping it all in one place having full control of my database.
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.