Access User Groups: Europe (AEU) - Meeting 22 - Dec 2023 : Info / Files

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

Meeting Details:

This Access Europe meeting was 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 is 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 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.

Colin Riddington will be leading a related presentation in the June 2024 session of Access Europe.
For further details, see View & Edit Import/Export (IMEX) Data Task Specifications


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 on his No Longer Set website, where he’s published over 1000 articles since 2020.
Mike first earned the Access MVP award in November 2021.

Mike Wolfe

Further Reading:

Mike has also published a series of articles on his No Longer Set website related to the topics covered in this session

      clsImExSpecs Presentation to the Access Europe User Group

      Creating and Editing Import Specifications via the Wizard

      Using the Wizard to Export to Text Files with Microsoft Access

      Documenting the Import-Export Specification System Tables


Click to download a PDF of the presentation used in this session together with the ACCDB FE database and related files:  

      IMEX Specifications Presentation     Approx 0.5 MB (PDF)

      IMEX Example Database & Files     Approx 1.1 MB (zipped)


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 13 Dec 2023

Return to Access Europe Page

Return to Top