Use One Function to Handle Many Form Events in MS Access

In this episode, we'll take a look at a little-known way to use event properties in Microsoft Access. By creating a single "sub-like" VBA function in a centralized module, we are able to set that function call as an event property on a form.. ..without writing a single line of "code-behind" for the form. The method can assist in simplifying functionality that is called on dozens or hundreds of events throughout an application by eliminating the need not only for repeated code in Event Procedures, but also Event Procedure code required to call centralized functions. Let's go!
Block spammers from harassing your Remote Desktop, filling your Windows security logs with failed RDP attempts, and burning up your bandwidth with my BZ RDP Cloaker:
buy.billzone.com/bzrdpcloaker...
Check out my easy time entry system for your business:
system.billzone.com/billzone
Join me on Patreon!
/ mackenziedataengineering
Check out some tech (and support my channel!):
www.amazon.ca/shop/seanmacken...
Want the code from this video?
mackenziemackenzie.com/downloads
For developers looking for a new role, check out and sign up:
www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
www.toptal.com/qKaO2b/worlds-...
Contact form you can find at www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/...
Got a KZbin Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenz...
#msaccess #vba

[@tomseed2000]

Another awesome video, THANKS!!!

[@seanmackenziedataengineering]

You bet!

[@peterhamer504]

Great little demo: so useful

[@seanmackenziedataengineering]

Glad it was helpful!

[@simonmaersk]

Thanks! Great tip for beginners

[@seanmackenziedataengineering]

I remember seeing this on another db back in the day when I first started, and was like, "you can do that??" lol

[@simonmaersk]

@@seanmackenziedataengineering Yeah haha. I wasn't aware either. But I frequently use the exact same trick on text boxes, so makes sense that it works on buttons as well!

[@glennbyerly4279]

Sean, functions typically are used to return a value of some kind. Why not just use a subroutine in a module and make it Public so it can be called from anywhere and provide the same result?

[@tuffley2175]

Handy way to skin a cat I like it PS If need to replace Access what is the next option would be (sql opt out)

[@seanmackenziedataengineering]

Many ways to do things indeed! If you need to replace something in text, you can use Replace kzbin.info/www/bejne/iGaQmK2Eppynndk