The applications on this page are free to download and free to use.
Almost all items are supplied with full program code and will work in both 32-bit and 64-bit Access version 2010 or later unless stated otherwise.
We do not give the same support to these programs as for our commercial programs.
However, please contact us if you have questions or suggestions for improvements.
Access Error Codes
Version 3.2 Last updated: 23 Oct 2022
This contains details of all VBA errors for Access 2010 as supplied by Microsoft
Access / Office 365 / Windows Version Check
Version 2.73 Last updated: 23 Dec 2022
This is a simple utility to check the following:
a) Windows version & bitness (32/64-bit)
b) Access version & bitness
c) Whether Office 365 is installed and the Update channel in use
Add Colour to Tab Control Pages
Version 1.3 Last updated: 5 Feb 2024
Access tab controls allow very little customisation. Pages can either be white or transparent. The page tabs only allow limited colours depending on the current tab state. This article shows one way of adding colour both to individual tabs and their pages.
Version 1.0 Last updated: 8 Jun 2022
This example app shows how a form can be opened at startup to display a set of randomly chosen tips. When the tips form is displayed the rest of the screen is automatically dimmed to get users' attention. Individual users may choose to hide the application tips if preferred.
ASCII Character Set
Version 1.0 Last updated: 23 July 2022
This is a quick reference database giving all the ASCII character codes (0-255). ASCII stands for American Standard Code for Information Interchange. An ASCII code is the numerical representation of a character such as 'a' or '@' or an action of some sort.
Attention Seeking Database
Version 6.9 Last updated: 20 Nov 2022
This app demonstrates various ways of getting users' attention.
As well as more familiar methods such as message boxes, features include:
- Flashing, scrolling and balloon tooltip text
- Dim / blur / remove background
- Use of warning sounds, text to speech, animation, fade & user messages
Auto position objects in extended Access interface
Version 1.4 Last updated: 23 Oct 2023
This example app shows how objects can be automatically positioned on different monitors in an Access application interface which is extended across two or more monitors.
Version 3.16 Last updated: 26 July 2023
An Access database can create up to 255 simltaneous connections to local & linked tables.
However, if a large number of connections are left open, the performance of the application will deteriorate & eventually it may crash with a message: 'Cannot open any more tables' or 'Cannot open any more databases'.
This utility can be used to monitor the number of open databases/tables that can be created before these errors appear.
Better Date Picker
Version 1.5 Last updated: 27 Mar 2023
This is a better date picker that has no Active X controls and can also be used in 64-bit Access.
The latest version automatically assigns the first day of week and regional date format to match those in Windows settings. In addition, it shows the day and month names in the regional language currently in use.
By request, it also now includes automatic form resizing
Build Your Own Simulated Split form
Version 1.1 Last updated: 5 Mar 2023
The built-in Access split form has several important limitations.
This article shows how you can create your own simulated split form which doesn't have the restrictions inherent with the built-in Access split form
Cascading Combo Boxes
Version 3.5 Last updated: 6 Mar 2019
This is the first in a series showing different ways of filtering and grouping data in Access.
Cascading combo boxes are particularly useful where you have a very large dataset that would be impossibly slow to search using a single combo box or listbox.
This is a cut-down version of the postcode builder used in the UK Postal Address Finder application (UKPAF)
CDO EMail Tester
Version 2401 Last updated: 8 Jan 2024
This is used to test sending HTML or plain text emails directly from Access without using Outlook. If there are issues with email settings, error messages are displayed to assist with fixing the problem(s). The latest version includes additional functionality.
This is compatible with both 32-bit & 64-bit Access and includes a fix for GMail issues
Version 2.1 Last updated: 6 Mar 2019
This is a companion to the Colour Converter / Selector example.
In earlier versions of Access, only 3 colour formats could be applied whether using VBA or the conditional formatting wizard. From Access 2010 onwards, the limit was significantly increased to 50 using the wizard but the limit of 3 formats still applies using VBA.
This example shows how to obtain an unlimited number of colour formats without using conditional formatting either in VBA or by using the wizard.
Colour Converter & Selector
Version 2.21 Last updated: 31 Dec 2020
This is a simple application to demonstrate two different methods for selecting and converting colours between the three different formats used by Access: OLE, RGB & HEX.
Combobox Auto Dropdown
Version 1.1 Last updated: 24 Oct 2022
This example app shows two methods of getting combo boxes to drop down automatically. This is particularly useful with cascading comboboxes (see separate article above)
The first method uses a button click event to trigger the first combo to dropdown
The second method uses a form timer event so the dropdown happens when the form loads.
Selecting any item in the first combo causes the second combo to drop down
Version 1.0 Last updated: 26 Oct 2018
This is a small puzzle for anyone interested.
The example application contains a form with a combo box whose row source is an empty value list. Yet the combo containds several values when viewed.
Can you work out where the combo list info is stored?
Better still can you re-create this scenario in another database?
Continuous subform selection using the vertical scrollbar
Version 1.7 Last updated: 16 July 2022
Normally, when the vertical scrollbar on a continuous form scrolls through the records, it doesn't change the 'current record' i.e. no selection is actually made without clicking.
However, this example app shows how records in a continuous subform can be 'selected' using the vertical scrollbar.
This can be useful for rapid record selection
Control the Application Interface
Version 3.63 Last updated: 20 Nov 2022
This example shows how the Access application interface can be controlled in various ways including hiding the navigation pane, ribbon, taskbar and the entire application window.
Some of these methods can be used to help make a database more secure.
Version 1910 Last updated: 16 Oct 2019
This is a countdown timer similar to that found on all smartphones.
Set the time interval (min /sec) and optionally play a selected sound (wav) file when time is up.
Create Custom Splash Form
Version 1.1 Last updated: 17 July 2022
This article and example app demonstrates how the Access splash screen can be replaced with your own custom splash form.
Currency Exchange Rate Tracker
Version 1.51 Last updated: 8 Mar 2019
This gets the latest exchange rates in JSON format from an online data source.
Exchange rates are updated daily for a selection of common currencies.
Changes in exchange rates can also be tracked over time and plotted as a chart.
NOTE: The free version of this app is supplied as an ACCDE file so code is not available.
However, full program code can be purchased for a small fee
Version 1.0 Last updated: 25 Jun 2017
This is a simple day tracker for counting the number of days since an event or until an event
Emulated Split Form
Version 11.0 Last updated: 9 Feb 2019
This demonstrates the use of an emulated split form which was designed to overcome many of the limitations of the standard version supplied with Access
Extend Access Across Multiple Monitors
Version 1.3 Last updated: 22 Oct 2023
This example app provides code that allows the Access application interface to be extended across two or more monitors. It can be used to show different forms or reports on separate monitors simultaneously or to simulate having a very large monitor.
Extended File Properties
Version 2.2 Last updated: 31 Dec 2023
This utility provides an easy way of obtaining and storing all the extended properties for an individual file or all files of a specified type in a selected folder.
Filter By Form
Version 1.1 Last updated: 30 Dec 2023
The little known filter by form feature can be used to set up multiple filter conditions in any bound form. It can also be used with tables and queries
Folder Image Viewer
Version 3.5 Last updated: 9 July 2022
This example app shows how to show thumbnails of all images in a selected folder / subfolders. The orientation of JPEG images from cameras / phones may also be rotated to ensure these are displayed correctly in Access
Freeze Columns in Continuous Forms
Version 1.3 Last updated: 14 Feb 2024
This 2-part article discusses the freeze fields feature in datasheet forms and demonstrates how similar functionality can be added to continuous forms.
Get Current Geolocation
Version 2.9 Last updated: 22 Apr 2019
This utility is used to determine your current geolocation in Access
It displays latitude, longitude and the address of your current location together with a map
Location services MUST be enabled in Windows settings.
A free Google Maps API key is required
Get Geolocation From Photos
Version 1.2 Last updated: 25 Oct 2019
This is a companion to the Get Current Geolocation utility
It displays the latitude, longitude, altitude and the date/time taken for JPEG images from mobile phones and digital cameras. A map is displayed showing the location where the photo was taken
Location services MUST be enabled in your camera/phone
A free Google Maps API key is required
Greyed Out Controls : Disable or Lock?
Version 1.2 Last updated: 14 Oct 2022
This article compares the effect of disabling and locking form controls
The advantages and disadvantages of each approach are compared. An example app is provided
Hide Duplicate Values in Continuous Forms
Version 1.2 Last updated: 22 Feb 2024
Access provides a very useful feature for hiding duplicate values in reports but this is not available in forms.
This is a two part article. The first part demonstrates how to hide duplicate (grouped) values for selected columns in continuous forms. This effect is achieved by modifying the form record source. The form becomes read only
The second part shows how you can make many read only forms editable. THe article focuses on forms where duplicate column values have been hidden using an aggregate query and a left join. However, the same approach can be used with forms based on crosstab queries etc..
Hide & Restore Selected Columns in Continuous Forms
Version 1.5 Last updated: 7 Feb 2024
Datasheet forms provide some very useful features that are missing in continuous forms.
For example, clicking on the column headers displays a shortcut menu allowing users to sort / resize / hide and freeze fields.
None of those features are natively available when clicking on column headers in continuous forms.
This two part article and example apps demonstrate three different ways of hiding selected columns in a continuous form. In the second article, the remaining columns are moved automatically leaving no gaps. The hidden columns can also be restored individually or all at once. The form can also be sorted and filtered with all filtered fields highlighted in green.
Hide Sensitive Data in Forms and Reports
Version 1.4 Last updated: 17 Nov 2022
This article explains different methods of hiding/showing sensitive data in forms and reports.
The advantages and disadvantages of each approach are compared. An example app is provided.
Highlight Control/Column in Continuous Forms
Version 1.2 Last updated: 26 Jan 2024
This article demonstrates how to highlight the selected control or column in continuous forms using transparency and almost no code
Highlight Current Control in Single Forms
Version 1.1 Last updated: 9 Nov 2023
This article describes a simple method of highlighting the current control on a form without requiring any code. The approach works for textboxes and comboboxes
Highlight Current Record in Continuous Form
Version 1.1 Last updated: 5 Nov 2023
This shows how you can easily highlight the current record in a continuous form.
The same approach is also demonstrated for an emulated split form.
Highlight Filtered Columns in Continuous Forms
Version 1.1 Last updated: 22 Jan 2024
This example app demonstrates how to highlight filtered columns in a continuous form
Very little code is required.
Highlight Required Fields
Version 1.2 Last updated: 10 Nov 2023
This article describes three different methods of highlighting required fields in a form.
The different methods use both message boxes and highlighting the controls where required data is missing.
Highlight Search Results
Version 1.2 Last updated: 14 Nov 2023
This article explains how you can highlight matched text from search results for use in both forms and reports.
Horizontal Continuous Form
Version 1.1 Last updated: 13 Mar 2023
This is a modified version of the horizontal continuous form demonstated by Karl Donaubauer for Access Europe in Jan 2023. This version was written by Neil Sargent and uses code in class modules to make the idea easy to replicate in your own apps
JET ShowPlan Manager
Version 2.7 Last updated: 26 Nov 2021
The Jet ShowPlan feature is used to view the execution plan of Access queries and SQL statements. The query execution plan is a set of instructions to the database engine that tell it how to execute a query as quickly as possible
In order to use the JET ShowPlan feature, you first need to setup the feature in the registry. This requires knowledge of the correct locations for several registry keys, some of which depend on Windows & Access versions & 'bitness' and whether Office 365 is installed.
The JET ShowPlan Manager application is designed to make this process as simple as possible.
Kiosk Style 'Locked' Database
Version 2.1 Last updated: 28 Aug 2017
A kiosk style database intended for use with a barcode scanner and which can be 'locked'
The main purpose is to maintain focus on an Access form by preventing users moving outside the database 'window'.
Limit the Number of Records
Version 1.1 First Published: 27 July 2022
This is a simple application demonstrating how the number of records in a subform can be limited to a specified value with minimal code required
Listbox Mouse Move Item Tooltips
Version 1.5 Last updated: 2 Jul 2022
This shows show how listbox items can be 'selected' using a mouse move event without clicking the listbox.
This can be used to show e.g. images and tooltips for each row item.
The code works even where a vertical scrollbar is needed to view all listbox items.
Live Currency Exchange Ticker
Version 1.2 Last updated: 31 Dec 2020
This is an alternative approach to viewing the latest currency exchange data in Access.
A web browser control is used to view LIVE data in a specified web page.
The example web page used includes two HTML snippet scripts available freely online:
- scrolling ticker tape format
- simple currency exchange table
The approach can be adapted to use any live data from the internet e.g. sports scores, share prices, weather forecasts etc
Logged In Users
Version 3.1 Last updated: 20 Oct 2018
This is an updated version of a old utility originally created by David Crake to view users logged into a selected database
This version works with both ACCDB & MDB files including those protected by a password.
Manage Label Printing
Version 1.2 Last updated: 15 Nov 2023
This example database provides additional functionality not available using the label report wizard.
This includes options to select different reports e.g. name/address, selected label sizes, add optional input text, print duplicate labels and leave blanks for working with partly used label sheets.
Multiple Group & Filter
Version 1.8 Last updated: 9 Jan 2019
This is the third in a series showing different ways of filtering and grouping data in Access.
It includes two different examples showing the use of multiple combo boxes & toggle buttons to filter, group data & chart data.
The examples are:
a) Student Target Group Explorer - as used in UK secondary schools to identify students
in specified target groups so that appropriate action could be taken and results analysed.
b) Incident Analysis - a modified version of a form used by clients working for Transport
for London (TfL) to analyse vandalism and graffiti incidents on the London tube network.
Both examples use fictitious data
Multiselect Filter in a Continuous Form
Last updated: 29 Dec 2023
Unlike datasheet forms, continuous forms do not have a multiselect filter option. This 2-part article shows how the feature can easily be added, either from the user interface or using VBA code.
Navigation Pane Helper
Version 2.3 Last updated: 19 Aug 2022
This utility was designed to replicate the huge number of options available from the navigation pane with as few clicks as possible in order to make its use more efficient.
Open New Form & Close Original Form
Version 1.3 Last updated: 7 Jan 2024
A simple example app to show the code sequence when opening a new form then closing the original form. The effect of opening a new form in dialog mode is also discussed.
Query Metadata Viewer
Version 2.12 Last updated: 1 Sept 2022
This utility was designed to display the metadata of each saved query and to view and edit the queries in SQL/Design & Datasheet views
Password Login (with Session Login Information)
Version 5.6 Last updated: 6 May 2023
This is an updated version of another old utility written by David Crake and is a companion to the Logged In Users utility.
I have converted it to ACCDB format and modified the code so it will work in any version of Access from 2007 onwards (32-bit or 64-bit)
Other changes include stronger encryption of passwords using an RC4 cipher, management of expired passwords and user access levels
Patient Login (Kiosk Mode)
Version 3.0 Last updated: 29 Oct 2018
This is the second in a series showing different ways of filtering and grouping data in Access.
It is an example of a typical patient login system similar to that used in my local medical practice. It would normally be used on a touch screen with no keyboard and occupy the entire screen (kiosk mode).
Populate Junction Table
Version 1.0 Last updated: 28 May 2022
The example database shows several ways of quickly adding records to a junction table.
This is mainly for use when a design change leads to a junction table being added after records have already been added to the two adjacent tables.
Version 2.1 Last updated: 15 Jan 2019
I was working on a project involving random events and calculating time intervals to millisecond accuracy. So I decided to use both ideas in a simple application for measuring reaction times and thought it might be fun for others to play with
The idea is to respond to an event that occurs after a random delay & in a random position on the screen.
Rich Text Editor
Version 1.1 Last updated: 1 Mar 2022
This article demonstrates the use of rich text in a long text (memo) field and shows how to view the underlying code. It also compares the use of rich text and true HTML in Access forms
Run External Apps from Access
Version 1.2 Last updated: 1 Feb 2024
This article shows how you can run external Windows applications from Access using hot keys specified in an Autokeys macro or from a custom ribbon.
Set Back Color of all Forms
Version 1.2 Last updated: 31 Jan 2024
This article demonstrates a simple method of achieving a consistent appearance / style in all Access forms without using Access themes or saved template forms
Set a group of controls as visible/hidden, enabled/disabled or locked/unlocked
Version 3.0 Last updated: 29 Jan 2022
This application demonstrates how to set various states of a group of controls at the same time using the Tag property.
Signature Capture & Ink Edit
Version 1.0 Last updated: 2 Oct 2017
Two example databases intended mainly for use with Windows tablets.
1. Capture customer signatures as images
2. Convert text input by hand into standard text
Sort Columns in Continuous Forms
Version 1.2 Last updated: 30 Jan 2024
This shows how you can sort columns in continuous forms by clicking the column headers.
Version 2.0 Last updated: 10 Sept 2017
This is a simple speaking clock to demonstrate the use of text to speech (TTS).
UK residents may recognise that it is based on the old speaking clock provided by BT.
SQL to VBA and back again
Version 3.23 Last updated: 14 Apr 2023
This is a an enhanced version of a utility originally created by Allen Browne.
It was designed to help developers convert query SQL to VBA (or vice versa)
Version 3.03 fixes issue with Copy to Clipboard in 64-bit Access
Version 3.23 - minor bug fixes mainly to remove old legacy code
Streamline Multiselect Filters Code in Continuous Forms
Version 1.5 Last updated: 16 Jan 2024
Unlike datasheet forms, continuous forms do not have a multiselect filter option.
Building on from my previous article, this shows how to streamline multiselect filter code for use in any continuous form using generic functions.
Student ICT Database
Version 1901 Last updated: 23 Jan 2019
Originally intended for use in schools and colleges.
This can be used to maintain students' (or staff) network user names and passwords easily.
Subform Shrink & Grow
Version 2.0 Last updated: 26 Jun 2018
This is a very simple application to show how, at the click of a button, a subform can be shrunk & hidden or made visible & enlarged.
The idea is to remove unwanted white space in a form when the subform is hidden
Synchronise Subform Scrolling
Version 2.0 Last updated: 28 July 2022
This shows a simple method of synchronising the horizontal or vertical scrolling of two (or more) subforms where no code is needed.
A second example shows a more powerful approach based on an updated version of Stephen Lebans' GetSetScrollbars code for both continuous and datasheet forms
Version 1.1 Last updated: 6 Mar 2019
The GetSystemMetrics API provides detailed information about system configuration and display settings. This article includes an example database for checking these values
System Tray Alerts
Version 1.7 Last updated: 4 Apr 2023
This application demonstrates how you can use Access to create popup messages in the system tray notifications area.
This is ideal if you want to alert users to issues such as:
- Product support or licence about to expire
- A new version available on the application website
Table Analyzer & Viewer
Version 2.2 Last updated: 18 Mar 2023
This utility allows you to quickly analyze the tables in any Access database. For each table, the table type, number of fields and records are displayed. You can also determine the size of each table, view its data and the table design. All field types can be handled including complex and calculated fields
The utility is available free as an ACCDE file. The source code is also available for purchase at a reasonable price.
Text to Speech
Version 2.0 Last updated: 2 Oct 2017
This is a simple demo to show how text to speech can be added to an Access database.
Translate & Speak
Version 4.3 Last updated: 15 Nov 2022
This application demonstrates the use of both Google Translate and Text to Speech in Access.
Text may be entered in (and translated to) any supported language (109 in total).
In addition, the text may be 'spoken' using any installed voice for that language.
Currently, voices are available for up to 35 languages in Windows 10.
UK Postcode Address & House Price Lookup
Version 1.2 Last updated: 8 Dec 2019
This app is used to get a list of addresses & house price info for selected UK postcodes together with the geo-coordinates and a static Google map for that postcode
This is a free cut down version of the UK Postal Address Finder app and is supplied as an ACCDE executable file. Source code can be purchased separately if required
UK Postcode Finder
Version 2.02 Last updated: 5 Dec 2017
This is a fully searchable database of all current UK postcodes. It provides more info than you'll ever need to know about each postcode together with a Google static map of the location
This is a free cut down version of the UK Postal Address Finder app
Using Combo Charts in Access
Version 1.0 Last updated: 3 Aug 2023
This article shows how to use combo charts to display two different sets of data on the same axes. This type of chart is also very useful for showing a fixed reference line on your chart
View Access Help
Version 1.2 Last updated: 23 Oct 2022
This app allows you to easily view help topics within the Access application rather than using online help in a web browser.
It includes a list of over 250 help topics displayed in a form listbox. Additional help topics can be added to the list
View All Database Objects & Metadata
Version 2.4 Last updated: 2 Feb 2024
This item allows you to view all objects in a database together with the metadata for each object.
The list of database objects is obtained from the hidden system table MSysObjects.
It is updated automatically as objects are added to or removed from the database.
The object metadata is the same as that shown in the navigation pane when using Details view
View & Edit Import/Export (IMEX) Data Task Specifications
Version 2.3 Last updated: 3 Dec 2023
A new wizard driven XML based system of Import/Export Data Tasks was introduced with Access 2010. However, ease of use has also led to greater obscurity in how it works
This utility can help manage these IMEX data tasks. It contains code to do the following:
a) View Import/Export Specifications
b) Execute Data Task / Run Data Task
c) Modify Data Task Path
d) Modify Data Task Destination
e) Rename Data Task
f) Delete Data Task
The utility is intended for use by program admins when deploying ACCDE or ACCDB files
View External Tables
Version 2.3 Last updated: 28 Nov 2019
This utility will list all tables in selected external databases. Users have the option of selecting any/all of the following types of table: local/ hidden/system/linked.
You can also view and (optionally) edit the contents of almost all external tables from the utility without actually linking the tables
It will work successfully:
a) with ACCDB / ACCDE / MDB / MDE files
b) with password protected files where this information is entered on the main form
c) on the current database
d) in 32-bit or 64-bit Access (there are no API declarations)
Web Version Checker
Version 2.0 Last updated: 12 Oct 2019
This example app is designed to show how users can be alerted to program updates on a specified web page.
Working with Time Zones
Version 2.3 Last updated: 11 Nov 2021
This free utility shows the current date & time in selected time zones with the times being updated each second. Daylight saving time adjustments are included where applicable
Return To Home Page
Return To Top