AEU Meeting Date: 6 Dec 2023 starting at 18:00 UK Time (UTC)                                        Page Last Updated 20 Sept 2023

Meeting Details:

This Access Europe meeting will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)

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

Please note that in December, the UK will be on Greenwich Mean Time (UTC). 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 AccessUserGroups.org 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.



Topic outline:

Learn how to programmatically update import/export specifications in Access with a custom VBA class.

In this presentation, Mike will demonstrate his clsImExSpecs class. This simplifies working with import and export specifications by writing and modifying simple VBA, rather than fighting with the unintuitive Access wizards.

•   How Access works with specifications behind the scenes
•   Why changing system tables directly can cause problems
•   Encapsulation, organization, and reusability benefits of classes
•   Using clsImExSpecs to document existing specifications in VBA
•   Streamlining workflows by avoiding context switching between code and UI
•   Demonstration updating a real-world import specification

By attending, you will gain practical tips for managing specification changes in code rather than through awkward and inconvenient Access wizards. You will also learn how VBA classes can be used to solve real-world problems, rather than the typical "Cat is a type of Animal" nonsense that you often find in online tutorials. 

Knowing when and how to effectively use class modules will take your VBA to the next level.

You should attend this presentation if you fall into one or both of the following categories:
•   You are frustrated with the Import/Export wizards in Access and want a better way to manage import/export specifications.
•   You keep hearing about how great class modules are, but you have no idea why or how you would use them.

NOTE:
See the official Access Europe web page for additional information about both this and all other Access Europe events


Bio:

Mike Wolfe - 3x Access MVP

Mike runs Grandjean & Braverman, Inc., specializing in Microsoft Access and SQL Server software solutions for government, banking, and insurance clients.
He writes daily articles about advanced Access and VBA topics at nolongerset.com, where he’s published over 1000 articles since 2020.
Mike first earned the Access MVP award in November 2021.






Video:

The video of this session will be edited and uploaded to YouTube a few days after the meeting.
This article will be updated with a link to the video when that happens



Colin Riddington           Mendip Data Systems                 Last Updated 20 Sept 2023

Return to Access Europe Page

Return to Top