Event Driven Programming with John Colby

Event Driven Programming using classes can expand the power of Access applications.

Long-time Access developer and author John Colby will demonstrate and explain using classes in your own applications.

Events are the very essence of MS Windows and every application running on it. Think about the two things that we will always have, a keyboard and a mouse, or a way to emulate those two things. As an Access programmer, one of the first things we learn is how to create an event handler. Drag a command button onto a form and then create a handler for the OnClick event for that button (a mouse event triggers that). As a result, all serious VBA programmers understand events and event handlers. What very few VBA programmers understand is how to create our own objects which can sink as well as raise events.

My discussion tonight will teach you how to do just that. By the end of the night you will understand what events really are, why you use them, and how you use them. I have written a demo program to let you see, play, touch and feel events and the code that handles them. I will demonstrate how to:

1) Create your own classes.

2) How to sink events inside of your own classes.

3) How to make your own classes raise events.

4) How to ‘wrap’ an access object such as a form, text box, combo box or list box in your own class and then extend the functionality of those objects, make them better, make them do what you want them to do.

5) How to step through the code and watch the event handling unfold.

Everything you see and use in Access are classes. We can make our own classes. Let me show you how. Nope, not the ‘Cat says meow’ kind of class, that is boring.

Download the presentation files from your AUG Access Pacific Dashboard.

Please join us for our Monthly Chapter Presentation on September 7th, at 6:30PM Pacific Time Zone
(Please verify your Time Zone offset with World Time Buddy.)

We might even get an advanced look at a new book.

Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.

Add AUG Pacific meeting to your_Outlook Calender


Please prepare ahead of time by downloading Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:

When it’s time, join the meeting from here:

Join Zoom Meeting

If you are asked:

Meeting ID: 861 2395 1916
Passcode: AUG_AP1!

Dial by your location
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
Meeting ID: 861 2395 1916
Passcode: AUG_AP1!
Find your local number: https://us02web.zoom.us/u/kd2h4C8v7w