Access User Groups: Europe (AEU) - Meeting 27: May 2024 - Info / Files

AEU Meeting Date 1 May 2024 starting at 18:00 UK Time (UTC+1)                            Page Last Updated 9 May 2024

Meeting Details:

This Access Europe meeting was held on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:30 (7.30PM)

The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST

Please note that the UK is currently on Summer Time (UTC+1). For local times, please check World Time Buddy

We use Zoom as our meeting application. Please click this link to Get Zoom if you don’t already have it.

When the time comes for the meeting, please use the following link: Join Zoom Meeting
If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210

For more connection options, please see the web page for this event

All sessions are recorded and later uploaded to the Access User Groups channel on YouTube

If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off during the meeting.

Download Outlook Calendar (.ics file):

Click to download. Save in Outlook to create a recurring event for each month:       Outlook Calendar (.ics)

Topic outline:

In this session, Adolph Dupré discussed some powerful techniques for using class modules.

He explained when you may want to use classes instead of User Defined Types (UDT). For example to manage the data in unbound forms.
Adolph then demonstrated VBA code to create class modules from tables and use the class created to populate/navigate/update a simple unbound form.
An example database is provided containing all the code used for this presentation.


Adolph Dupré
Adolph describes himself as a solutions provider who uses IT to create the best solution.
He writes custom programs for companies that can’t find a ready-made solution that meets their needs. For example: powerline maintenance, vending co-operative

Adolph is based in the USA and has been programming for the last 40 years. His primary focus is VBA but he also has experience in DOS, VB, C++, PHP, Python, ASP, ASP.NET, Ajax.

He has designed applications to interface with many third party programs such as QuickBooks, Twilio,, Electronic Medical billing, speech recognition, barcode scanners and electronic signature pads.



Click to download a zip file containing a PDF of the presentation used in this session together with an updated version of the example database and all code:
        Class Module From Table     Approx 1 MB (zipped)

UPDATE 9 May 2024: The updated database fixes a minor error in the original release


The meeting was recorded and the video is now available on the Access Europe YouTube channel at or you can click below:


Colin Riddington           Mendip Data Systems                 Last Updated 9 May 2024

Return to Access Europe Page

Return to Top