Use One Function to Handle Many Form Events in MS Access

Published: 28 May 2024
on channel: 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


Watch video Use One Function to Handle Many Form Events in MS Access online without registration, duration hours minute second in high quality. This video was added by user Sean MacKenzie Data Engineering 28 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,755 once and liked it 68 people.