Use One Function to Handle Many Form Events in MS Access

Опубликовано: 28 Май 2024
на канале: Sean MacKenzie Data Engineering
1,755
68

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:
https://buy.billzone.com/bzrdpcloaker...

Check out my easy time entry system for your business:
https://system.billzone.com/billzone

Join me on Patreon!
  / mackenziedataengineering  

Check out some tech (and support my channel!):
https://www.amazon.ca/shop/seanmacken...

Want the code from this video?
http://mackenziemackenzie.com/downloads

Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html

Want my team to do a project for you? Let's get to it!
https://system.billzone.com/smdeproje...

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...

#msaccess #vba