First Published 22 Aug 2022                 Last Updated 2 Oct 2026

Access Europe (AEU) is an online chapter of AccessUserGroups.org

This virtual group meets on the first Wednesday of each month, from 18:00 – 19:30 UK Time and is chaired by Colin Riddington. Meetings are hosted using Zoom

We provide a forum for IT professionals, developers and new users to share and learn about Microsoft Access.

The group focus is on innovative and lesser known features in Access. An invited speaker gives a presentation on a topic relevant to Access developers for the first 50 minutes of each session.
The remaining time is used to answer questions, share ideas and suggest topics for future sessions.

Each meeting is recorded and the video is uploaded to the Access Europe YouTube channel soon after the event. Many speakers provide files related to their session. These files can be downloaded from the linked page for that meeting.

Details for future events together with connection information are available from the Event Calendar on the AEU website where you can also choose to sign up as a subscriber.

AEU subscribers receive an email reminder about 7 days before each event.

We would love to see you at our virtual meetings. Please join us online at Access Europe.

Please email me if you have a topic you would like to see covered in a future meeting or if you would be willing to lead a session on a specific topic.



YouTube Videos


Click to view the Access Europe YouTube playlist featuring videos of all our previous meetings.

This is the most recent video:





Topic Outline (A-Z)


32 to 64-bit Conversion (Peter Cole)

Meeting Date: 3 Aug 2022

Peter Cole explained how to make the process of converting a database for 64-bit Access as simple as possible.

The main consideration is normally the need to convert API declarations from 32-bit to 64-bit.

Peter demonstrated three related apps he has created for this task:
a)   free API scanner that shows the number of declare statements in a database providing an idea of the size of the updating task.
b)   free API Viewer that provides the declarations for 64-bit.
c)   commercial 32 to 64-bit updater app showing some sample updates.

The two free apps and the session video are available from the link below


More Details



A Baker's Dozen of Tips, Tricks & Tools in Access (Karl Donaubauer)

Meeting Date: 4 Jan 2023

Long time Access developer and MVP, Karl Donaubauer demonstrated 15 of his favourite tips, tricks and tools.

Karl is constantly collecting techniques, tools, solutions and explanations that you don’t hear and read everywhere. This time for example:
•   Access/VBA settings overlooked for decades
•   how to program Access properties in VBA that don’t exist in VBA
•   how to get return code (exit code) from external programs
•   finally, the horizontal continuous form
•   a tool to generate & integrate QR codes at the push of a button
•   a tool that generates professional related test data
•   context menus without right mouse, colours in combo and list boxes… and other small stuff

So even if you think you already know everything about Access, this session is guaranteed to show you something completely new or that you've forgotten.

More Details



Access Studio (Chris Arnold)

Meeting Date: 6 Apr 2022

The free Access Studio add-in was created by Chris Arnold of SME Data Solutions

The main purpose is to add much of the functionality of SQL Server Management Studio to Access apps.

The free version of Access Studio and the session video are available from the link below.

More Details



Advanced Techniques with Interactive Gantt Charts (Aleksander Wojtasz)

Meeting Date: 4 Sept 2024

In July 2023, Aleksander gave an excellent presentation on the use of his Interactive Gantt Chart Scheduler in Access. The session was very popular and the accompanying YouTube video has had by far the highest number of views (over 3400 to date) of all our meetings so far.

We were very pleased to welcome back Aleksander for a follow-up session where he explored more advanced techniques with interactive Gantt charts.

In this session, Aleksander explained how he upgraded the code which now uses a class module approach. The Scripting Dictionary is used to manage the size and position of objects placed on the screen.

More Details



AI Assistants – Bring your knowledge to the smartest AI models (Alexander Denz)

Meeting Date: 5 Mar 2025

In this session, Alexander Denz demonstrated how you can build AI assistants and integrate them as add-ins into your Access applications. You can also build custom ribbons or let the AI assistants help you in the VBA editor.

More Details



Annotating Google Maps in Access (Colin Riddington)

Meeting Date: 7 Dec 2022

Colin Riddington demonstrated ways of annotating downloaded static Google Maps to personalise these for your clients.

Topics covered included the use of:
a) marker points e.g. to mark client locations or nearby places
b) lines joining 2 or more points e.g. to indicate routes between locations
c) circles around a location e.g. to show places of a specified type within a specified distance from a set location
d) boundary shapes e.g. to show postcode or regional boundaries
e) feature styles e.g. to mark major & minor roads and points of interest

Annotations are added as additional map layers using code as part of the URL used to generate the map.

The session also explained how to overcome issues caused by the 2083-character URL limit using the current web browser control based on Internet Explorer (whilst we continue to wait for the new Chromium Edge browser control).

More Details



Automating DSN-Less Connections to SQL Server (Peter Bryant)

Meeting Date: 3 May 2023

Peter Bryant demonstrated code (and some data) to enable you to fire and forget application upgrades to different networks.

Send your client the ACCDE that works on your development network and have it automatically re-connect to their server and database on first run.

The test application (supplied as a download) also demonstrates how you can switch the front end between your (or your users’) TEST, UAT and LIVE environments at just the click of a button (subject to version numbering).

More Details



Better Access Charts – The Next Generation (Thomas Moeller)

Meeting Date: 6 Mar 2024

This session was led by Thomas Moeller and was a continuation of his Access Europe presentation from February 2023. Thomas demonstrated the significant changes in Better Access Charts since that time.

More Details



Building Ribbon Interfaces in Code (Mike Wolfe)

Meeting Date: 6 Jul 2022

Mike Wolfe (MVP) explained how he builds Access ribbon interfaces in VBA code.

A class module is used to generate ribbon XML at runtime.

The sample app and PDF presentation from this session together with the session video are all available from the link below

More Details



Cataloguing and searching emails with Access (Alessandro Grimaldi)

Meeting Date: 5 Oct 2022

Alessandro Grimaldi demonstrated an Access application which communicates with Outlook to catalogue incoming emails. This was originally created for the European Central Bank, but the ideas can be adapted for any business or for personal use.

A rather sophisticated 'filter builder' is implemented, to create flexible and reusable queries to select emails matching specific criteria.

More Details



Classic vs Modern Charts (Crystal Long)

Meeting Date: 4 May 2022

Crystal Long (MVP) compared the two types of charts available in Access – the original 'classic' charts and the newer 'modern' charts available as an update to Access 2016 and all later versions including 365.

Modern charts have a better user interface with more colors to pick from. Classic charts have more power and flexibility but aren’t as intuitive to modify.

The session discussed the capabilities, advantages and disadvantages of each to help you decide which is right for your application.

A link to the files from this session together with the session video are available from the link below

More Details



Command Bars, the Access Shortcut Tool and a Simple Audit Log
(Dale Fye)

Meeting Date: 3 Apr 2024

This session was led by Dale Fye (MVP 2013-2016). Dale first discussed his Advanced Shortcut Tool for working with Command Bars. He then explained a Simple Audit Log he created for a client.

More Details



Creating an Advanced Data Grid Integrated with Access
(Aleksander Wojtasz)

Meeting Date: 4 Feb 2026

Aleksander Wojtasz demonstrated how to use the new Access Edge browser control to visualize data in a grid format.

More Details



Creating calendar format reports (Duane Hookom)

Meeting Date: 5 Apr 2023

This month’s session was led by Duane Hookom (MVP 2001-2016). Duane's presentation demonstrated techniques for data reporting in calendar formats.

The same, simple method could be used to print seating charts and other spatial data.

More Details



Custom Ribbons Using Command Bars (Adrian Bell)

Meeting Date: 6 Dec 2024

Building on his recent presentation for the Access Pacific User Group in Sept 2024, Adrian Bell (MVP) demonstrated how to create a custom ribbon using Command Bars.

More Details



Database Analyzer and other tools (Colin Riddington)

Meeting Date: 6 Sept 2023

This session was led by Colin Riddington (MVP) who demonstrated his new Database Analyzer and Viewer utility

More Details



Developing COM Add-Ins for Microsoft Access (Philipp Stiefel)

Meeting Date: 8 Jan 2025

In this presentation Philipp Stiefel demonstrated the key elements of creating COM add-ins for Microsoft Access. The same principles can also be applied to create COM add-ins for other Microsoft Office desktop applications, including Excel, Word, and PowerPoint.

More Details



Drag and Drop: behind the scenes (Alessandro Grimaldi)

Meeting Date: 2 Oct 2024

In this month's presentation, Alessandro Grimaldi demonstrated several examples of his Access interactive interfaces, including some of already presented at Access DevCon in recent years.

This time, to address the many requests he has received, he also went ‘behind the scenes’, and sketched the code structure of his ‘drag and drop’ engine, on which most of them are based.

More Details



Extending Access with SQL Server & Geography data (John Heaser)

Meeting Date: 20 Nov 2023

This session was led by John Heaser who is an experienced Access developer based in the U.K.

SQL Server has a Geography data type that can represent points, lines and polygons on the Earth’s surface. This data can be used to:
•   Find which polygons contain a point:
•   Find the points that lie within a radius of a starting point and order them by distance:

This can be very useful for many purposes and SQL Server calculates the results very fast - provided that suitable Spatial Indexes are defined.

Unfortunately Access can’t work directly with Geography data types!
However, you can make use of Geography data in Access by using:
•   Persisted Computed Columns
•   Scalar Functions
•   Stored Procedures
•   Triggers

We will look at how these SQL skills can be used to bring the benefits of Geography data types to Access.

The same skills can also be used to leverage the power of SQL Server to do other tasks that would be slow to perform or difficult to code, if done directly in Access.

More Details



Faking ‘Non-Normal’ User Interfaces with Normal Data (Pete Poppe)

Meeting Date: 2 July 2025

Many forum threads are based on databases where people have built non-normal tables in order to show data in the way they want.
Typical examples include daily schedulers, surveys, checklists and hierarchical data.

This approach is sometimes known as the 'Excel in Access' mentality and is often because of limitations of what you can do out of the box with standard forms and subforms.
In this presentation, Pete covered several techniques to build “non-normal” interfaces while keeping the data normal. This included features such as:
•   Use of temp tables
•   Use of cross tabs for interface
•   ADO in memory recordsets
•   Custom unbound forms to act as a user control
•   Treeviews (light discussion)
•   Advanced sub data sheets

The idea was to expose the audience to some tips, tricks, ideas and approaches more than explaining the code. Many examples were provided.

More Details



GraphAuthenticator - the 'New Outlook' problem solved
(Andrew Richards & Peter Bryant)

Meeting Date: 7 Oct 2026

With the push toward “New Outlook” intensifying, it’s no longer safe to write or use code assuming that Outlook Automation is available. Microsoft’s answer to this is to use the Graph API to send emails – but if you’ve got 2FA turned on, that’s a problem, because VBA can’t work with M365’s multi-factor authentication.

Peter and Andrew have a solution. Their new tool – GraphAuthenticator – allows VBA code in any application to connect to the Graph API and seamlessly authenticate with MFA, allowing access to a huge range of API calls to work with emails, calendars, contacts, SharePoint, OneDrive, Microsoft Bookings and more.


More Details



High impact – Custom dialogs and mini-notifications (Marcus Dieterle)

Meeting Date: 1 Oct 2025

No more boring standard dialogs - time for custom build dialogs!
Anyone who works with Access knows them all too well: MsgBox and InputBox. Functional? Yes. Modern, appealing or user-friendly? Unfortunately not.

Marcus presented his new dialogs. These are myMsgBox, myInputBox, myComboBox, and myNotification. These can be used to display not only formatted text, but also images and tables.

More Details



Image / Photo Cataloguer in Access (Chris Arnold)

Meeting Date: 6 Nov 2024

In this presentation, Chris demonstrated his very versatile image/photo cataloguer.
This allows the user to catalogue the pictures – perhaps a place name, a project, a person, an event or maybe your hobby collection.

The cataloguer uses a web browser control to display images and a continuous form as a multi value treeview control to provide selected cataloguing data and a ‘swipe right’ action to apply the selection to the image and a ‘swipe left’ option to delete unwanted images.

More Details



Improved, Enhanced Message Box (Olaf Nöhring)
Enhancing Access forms (André Minhorst)

Meeting Date: 3 July 2024

In this session, we had two presenters from Germany - Olaf Nöhring and André Minhorst.

Olaf discussed his improved version of the free Enhanced Message Box first developed by Renaud Bompuis over 15 years ago.

André introduced two exciting enhancements for Access applications, designed to streamline and enhance user experience.

More Details



Inaugural Meeting (Colin Riddington/Alessandro Grimaldi)

Meeting Date: 2 Mar 2022

Welcome to the first session of Access Europe - the latest chapter of AccessUserGroups.org.

The meeting was co-hosted by Colin Riddington and Alessandro Grimaldi with an introduction by Juan Soto, president of AccessUserGroups.org.

It included short demonstrations of innovative Access apps by both Colin & Alessandro together with a 'get to know you' section where all audience members told us a little about themselves.

The session video is available from the link below

More Details



New and Forthcoming Features in Access (Colin Riddington)

Meeting Date: 6 Aug 2025

In this session, Colin demonstrated several recently released new Access features including:
•   VBA support for modern charts
•   command line project signing and timestamping
•   new Create SQL Query button
•   significant improvements to the Monaco SQL editor.

He also discussed the scope of two significant new Access features that will be rolling out to users later this year: Responsive Forms and Large Monitor Support
•   Add Zoom slider magnification to Microsoft Access
•   Modernize Access Forms and Reports to work well on Large Format Monitors

More Details



Northwind 2.0 Developer Edition – Inventory and String functions (Tom van Stiphout & Kim Young)

Meeting Date: 7 June 2023

A team of five experienced Access developers led by Tom van Stiphout (MVP) have created two completely new versions of the Northwind (Starter & Developer) template database.

In this session, Tom Van Stiphout and Kim Young presented an in-depth treatment of several important features in the new Northwind Developers template database:
a)   Introduction to the approach used in creating the two new versions of Northwind
b)   Quick recap of the POs, products, and orders we have in the sample db.
      In depth discussion of the Inventory. Reallocate. Order detail status changes.
      What changes could you make to the NW2 inventory? Split off an order.
c)   Employee form. Custom dialog. String functions. OpenArgs.

More Details



Optimizing Queries & the JET ShowPlan (Colin Riddington)

Meeting Date: 7 Sept 2022

Colin Riddington explained various ways of optimizing the query execution plans created by Access when queries are run.

During the session, a series of speed comparison tests were performed showing the effect of each suggested change on the query execution.

In addition, the session was used to discuss two little known features that can help explain how Access runs queries:
a)   JET ShowPlan – used to view the query execution plans
b)   ISAMStats – used to determine the number of Disk Reads / Writes / Locks when queries are run

All the files used in the session together with and the session video are available from the link below

More Details



Optimizing Queries in SQL Server (Maria Barnes)

Meeting Date: 1 Mar 2023

Maria Barnes discussed how to optimize queries in SQL Server using various tools provided in SQL Server Management Studio (SSMS):
     - How to decide which SQL queries need to be optimized?
     - How to Use the Activity Monitor in SSMS
     - An Introduction to the Performance Dashboard for SSMS 17.2 and above
     - Query Simplification Basics
     - Displaying the Estimated Execution Plan in SSMS
     - A brief mention of the Query Store and what this is

More Details



Orchestrating Office: Amplifying Access with Multi-Application Automation (Domenico Ruggiere)

Meeting Date: 4 June 2025

In this session, Domenico Ruggiere (AKA the Software Maestro) discussed multi-app solutions that involve Access and SQL Server as a foundation for serving up exports to Excel / PowerPoint / Word.

More Details



Power Apps for Access Developers (George Hepworth)

Meeting Date: 2 Nov 2022

The session was presented by George Hepworth AKA Grover Park George. George was an Access MVP from 2007-2019 and is still very active in the Access community.

Microsoft Access on the desktop and MS Power Apps in the browser can make a powerful team.

In this presentation, George provided an overview of the hybrid model for an application involving:
a) a "cloud" data source
b) a desktop interface in Access
c) a browser/smart device interface in Access

George also discussed some of the issues you might confront when implementing a PowerApps application, and possible approaches to resolving them.

More Details



Spot the Difference – A new style MsgBox for Access (Neil Sargent)

Meeting Date: 7 Jan 2026

Neil Sargent demonstrated how he has replicated the new style message boxes rolling out across Office apps and explained the journey to get there.

More Details



Sprinkle a little UI Magic on your Access apps (Colin Riddington)

Meeting Date: 11 Nov 2026

Colin Riddington will demonstrate several ways of enhancing the appearance of your Access apps including: supercharge continuous forms, move and resize borderless forms, personalise popup forms, theme-aware forms and FluentUI message boxes with timeout .

More Details



SQL Server Tips and Tricks for Access Developers

Meeting Date: 1 Jun 2026

This session will provide tips and tricks to make SQL Server work for you, not against you. Kevin Bell will cover several SQL Server features that are proven but are not widely known or used by Access developers. The focus is on practical changes that deliver improvements in readability, manageability, and performance.

More Details



Standard Module Object Generation (Alan Cossey)

Meeting Date: 1 June 2022

The free Standard Module Object Generation (SMOG) add-in was created by Alan Cossey of Premier Data Technologies Ltd.

It was developed in order to make as much use as possible of both compile-time error-checking and Intellisense in Access.

The free SMOG add-in and other supporting files are available from the link below

More Details



State-of-the-art charts in Access with chart.js (Thomas Möller)

Meeting Date: 1 Feb 2023

This month’s session was led by Thomas Möller (MVP 2007-2016). It was used to demonstrate the use of Javascript libraries to build state-of-the-art charts in Access.

In this presentation, Thomas demonstrated:
      •   How to get state-of-the-art charts (based on chart.js) running in Access
      •   The external dependencies and how they can be handled
      •   How the whole feature can be coded elegantly and clearly

More Details



Streamline Import Spec Workflow with VBA Classes (Mike Wolfe)

Meeting Date: 6 Dec 2023

This session was led by Mike Wolfe, MVP

Learn how to programmatically update import 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

More Details



Streamlining Form Module Code in the standalone Class Module
(APR Pillai)

Meeting Date: 3 Jan 2024

This session was led by Ramachandran (APR) Pillaiwho will be doing a deep dive into the use of class modules to streamline form and report module code.

During the course of this session, you will learn how to make effective use of class modules to streamline form and report event code.

More Details



The Future of Access (Juan Soto)

Meeting Date: 4 Oct 2023

This session was led by Juan Soto, MVP, President of AccessUserGroups.org. He discussed why many people wrongly believe that Access is dying and how as Access developers we can counter those repeated rumours.

More Details



Top 10 Advanced Features of MZ-Tools (Carlos Quintero)

Meeting Date: 7 Feb 2024

This session was led by former MVP, Carlos Quintero.

In this session, Carlos demonstrated features of his highly regarded VBE add-in, MZ-Tools, that can make you more productive and create better code in VBA.

There are features to code faster, to find code faster, to review the quality of the code and much more.

More Details



UI Tips/Tricks and New Access Features (Colin Riddington)

Meeting Date: 1 July 2026

In this session, Colin will demonstrate a number of user interface (UI) tips and tricks with windows, forms and messages. He will also review the new features that are rolling out to Access this summer.

More Details



Update, update . . . the company is in a state! (Karl Donaubauer)

Meeting Date: 7 May 2025

This session was led by long-time Access MVP, Karl Donaubauer.

Every now and then, Microsoft's automatic updates deliver bugs that are just a little annoying or, in the case of critical applications, can bring the company to a standstill.
Access users and developers tremble in the face of Office Patch Tuesdays and all the security and Windows updates.

But it doesn't have to be that way! Dr. Donaubauer will be here to educate you on prevention, help with clarification and diagnosis, and prescribe treatment and healing.

More Details



Using AI for Test Driven Development in Access (Mike Wolfe)

Meeting Date: 2 Dec 2026

Mike Wolfe will demonstrate how he combines various tools including AI to fully automate and verify the implementation of new features and the fixing of bugs in Access applications.

More Details



Using AI to create Open Template Scaffolds (George Hepworth)

Meeting Date: 7 Oct 2026

George Hepworth will outline his recent journey using AI to create the structures for Access template files.

More Details



Use SQL Geography data in Access (John Heaser)

Meeting Date: 1 Nov 2023

This session was led by John Heaser who demonstrated how to make use of SQL Server's very powerful Geography datatype to handle spatial data in Access

More Details



Use the Edge browser control to extend Access (Marcus Dieterle)

Meeting Date: 5 Aug 2026

This session will be led by Marus Dieterle who will demonstrate several ways of using the Edge browser control to extend the functionality of Access

More Details




Using ADO Recordsets in Access (Chris Arnold)

Meeting Date: 4 Mar 2026

This session was led by UK developer, Chris Arnold.
He will demonstrate the uses of ADO recordsets in Access together with their advantages and limitations. />

More Details



Using Class Modules in the real world (Anders Ebro)

Meeting Date: 2 Apr 2025

This session was led by former MVP, Anders Ebro.

He provided an introductory session on class modules – and then explained how to use them in real world scenarios.

More Details



Using Grid Lanes in Access (Tim Finch)

Meeting Date: 6 May 2026

Tim Finch will be demonstrating the use of Grid Lanes. This is a 2-dimensional grid on which users can place draggable objects and also place text inside. It is all programmed with GDI commands.

More Details



Using Power Automate with Office Apps (Ynte Jan Kuindersma)

Meeting Date: 5 Nov 2025

Ynte Jan Kuindersma demonstrated how to use Power Automate to send mail, create calendar events, and work with contacts. Besides that, flows can do a few hundred more things.
Setup is easy as Power Automate is incorporated in your Office 365 suite, and the security is guarded by Entra ID. For some actions you will need an extra license though.

More Details



Using Treeviews with Access Applications (Pete Poppe)

Meeting Date: 7 Aug 2024

In this presentation, Pete Poppe introduced the Treeview control and demonstrate when it can greatly benefit the display of certain types of data within Access applications. In particular, treeviews provide a means to show hierarchical data in a compact but expandable form.

Access does not have a native Treeview control but there is an Active X and third-party versions.

The presentation will provide basics on working with the treeview and provide a “wrapper” class that makes working with treeviews much simpler.

More Details



Using Twilio for texting from Access (Adolph Dupré)

Meeting Date: 3 Dec 2025

In this session, Adolph Dupré demonstrated how to use Twilio to send text messages from Access, either to selected individuals or a batch of text messages to a group

More Details



Using VBA to Create a Class Based on a Table (Adolph Dupré)

Meeting Date: 1 May 2024

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.

More Details



Using VBE_Extras add-in with Access (John Mallinson)

Meeting Date: 5 Feb 2025

In this session, John Mallinson demonstrated some of the most useful features of his VBE_Extras add-in for use with Access and other Office applications.

More Details



Using vbWatchdog in Access (Peter Cole)

Meeting Date: 1 Apr 2026

In this presentation, Peter Cole demonstrated using the vbWatchdog - Global Error Handler and Tracing utility from EverythingAccess together with his free vbWatchdog Unleashed system.

More Details



Version Control for the Sole Developer - Why it Matters (Adam Waller)

Meeting Date: 3 Sept 2025

Version control isn’t just for teams — it’s the secret weapon for sole Access developers to save time, avoid mistakes, and work with confidence.
This session was presented by Adam Waller, the lead developer of the free open source VCS Add-in.

More Details



Working with the Windows API (John Mallinson)

Meeting Date: Postponed from 2 Sept 2026 - new date t.b.c.

Working with the Windows API from VBA code has long been seen as a "black art". Trying to decipher how to use a particular function can be a dispiriting process.
In this presentation, John Mallinson will throw some light onto this process so that you can decipher the online MS Docs with more confidence and a better chance of success.

More Details