First Published 22 Aug 2022 Last Updated 23 Oct 2024
Access Europe (AEU) is an online chapter of the AccessUserGroups.org
This virtual group meets on the first Wednesday of each month, from 18:00 – 19:00 UK Time and is co-chaired by Colin Riddington and Alessandro Grimaldi. 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 with an invited speaker discussing a topic relevant to Access developers for the first 45 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.
Details and files for each meeting are added here soon after each session
AEU subscribers will receive an email reminder about 10 days before each event
We would love to see you at our virtual meetings. Please join us online at Access Europe
Please email us 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 of Access Studio 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 are very pleased to welcome back Aleksander for a follow-up session where he will explore more advanced techniques with interactive Gantt charts.
In this session, Aleksander will explain how he has 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
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 month’s 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 will be led by Dale Fye (MVP 2013-2016). Dale will first discuss his Advanced Shortcut Tool for working with Command Bars. He will then explain a Simple Audit Log he created for a client.
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
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
Drag and Drop: behind the scenes (Alessandro Grimaldi)
Meeting Date: 2 Oct 2024
In this month's presentation, Alessandro Grimaldi will again show 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 will also go ‘behind the scenes’, and sketch 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 will be 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
Image / Photo Cataloguer in Access (Chris Arnold)
Meeting Date: 6 Nov 2024
In this month’s presentation, Chris will demonstrate his very versatile image/photo cataloguer.
The cataloguer allows the user to catalogue the pictures – perhaps a place name, a project, a person, an event or maybe your trainspotting or floral 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 will have two presenters from Germany - Olaf Nöhring and André Minhorst.
Olaf will be discussing his improved version of the free Enhanced Message Box first developed by Renaud Bompuis over 15 years ago.
André will introduce 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
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
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
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 will be 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 will be 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
Using Treeviews with Access Applications (Pete Poppe)
Meeting Date: 7 Aug 2024
In this presentation, Pete Poppe will introduce 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 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 will demonstrate some of the most useful features of his VBE_Extras add-in for use with Access and other Office applications.
More Details
Colin Riddington Mendip Data Systems Last Updated 23 Oct 2024
Return to Home Page
Return to Top