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

More Details



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

More Details



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.

More Details



Application Tips

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.

More Details



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.

More Details



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

More Details



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.

More Details



Available Connections

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.

More Details



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

More Details



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

More Details



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)

More Details



CDO EMail Tester

Version 2408             Last updated: 21 Aug 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

More Details



Colour Conditions

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.

More Details



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.

More Details



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

More Details



Combobox Zombies

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?

More Details



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

More Details



Control the Application Interface

Version 3.65            Last updated: 13 June 2024

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.

More Details



Countdown Timer

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.

More Details



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.

More Details



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

More Details



Datasheet Row/Column Select & Spell Check

Version 1.1            Last updated: 9 Apr 2024

Datasheets allow you to select columns from the column header and rows using the record selector.
Surprisingly there appears to be no simple direct command available to do this programmatically.

A no-code approach is to add the Spelling command to the right click context menu for datasheet columns.
This example app demonstates a workaround showing how to select datasheet rows and columns using code.

More Details



Day Tracker

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

More Details



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

More Details



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.

More Details



Extended File Properties

Version 3.4            Last updated: 27 May 2024

This utility provides an easy way of obtaining and storing all the extended properties for:
•   an individual file
•   all files of a specified type in a selected folder
•   all files in a selected folder and (optionally) its subfolders

The extended properties data can also be exported to Excel as a list or a crosstab query

More Details



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

More Details



Fix Issues with Hidden Duplicates in Reports

Version 1.1            Last updated: 25 Feb 2024

This article shows four different methods of fixing issues when the Hide Duplicates features gives undesirable results in Access reports

More Details



Folder Image Viewer

Version 3.6            Last updated: 25 Oct 2024

This example app shows how to show thumbnails of all images in a selected folder / subfolders. The orientation of JPG images from cameras / phones may also be rotated to ensure these are displayed correctly in Access

More Details



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.

More Details



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

NOTE:
Location services MUST be enabled in Windows settings.
A free Google Maps API key is required

More Details



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

NOTE:
Location services MUST be enabled in your camera/phone
A free Google Maps API key is required

More Details



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

More Details



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..

More Details



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.

More Details



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.

More Details



Hide the Taskbar Icon

Version 1.5     Last updated: 14 June 2024

This example app demonstrates two solutions to a deceptively difficult task: hiding the taskbar icon for an Access application

More Details



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

More Details



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

More Details



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.

More Details



Highlight Entire Form (Dim Background)

Version 1.1    Last updated:19 Mar 2024

This article shows a simple way of focusing users' attention on a popup form by dimming or removing the background. This requires just one line of code in the form load and unload events.

More Details



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.

More Details



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.

More Details



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.

More Details



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

More Details



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.

More Details



Kiosk Example Form

Version 1.1            Last updated: 29 Jun 2024

This is an example of a simple kiosk style form which fills the entire screen when in use. There is no title bar, no Access application window and no taskbar.
This type of form is often used with a touch screen monitor in a public place e.g. my Patient Login app

More Details



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'.

More Details



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

More Details



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.

More Details



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

More Details



Lock Down Database Objects

Version 2.2            Last updated: 27 Mar 2024

This article demonstrates one way of protecting all database objects from unwanted modification. The example app prevents users opening, deleting, exporting or changing the design of tables, queries, macros & modules from the navigation pane.

Forms and reports can be opened by any standard method but the design cannot be changed. Interaction using the VBE and Immediate window is also highly restricted.



More Details



Lock Selected Records in Continuous Forms

Version 1.2            Last updated: 11 Sept 2024

This demonstrates how selected records can be locked in contnuous forms whilst allowing all other records to be edited normally.

More Details



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.

More Details



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.

More Details



Move Application Window Using Code

Version 1.1            Last updated: 28 May 2024

This example app shows how the application window can be moved using code. This can be useful for switching the currently visible application e.g. to temporarily switch betweeen Access and PowerPoint during a presentation.

More Details



Move/Resize Borderless Form Using Mouse Events

Versions 1.1 / 3.4            Last updated: 14 Mar 2024

Most forms can be moved by dragging whilst holding down the mouse on the form title bar. Sizable forms can also be resized by dragging the mouse over the form border. However, neither of these are possible for a borderless form.

This two part article shows how a borderless form can be both moved and resized using a combination of mouse down and mouse move events. Doing this requires surprisingly little code and very few API calls.

More Details



Move/Resize Selected Columns in Continuous Forms

Versions 1.9 / 2.1            Last updated: 29 Feb 2024

Datasheet forms provide some very useful features that are missing in continuous forms. For example, users can move and resize columns. This feature is not natively available in continuous forms.

This two part article shows how continuous forms can be modified to allow repositioning and/or resizing of selected columns. The articles include example apps with all required code.

More Details



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

More Details



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.

More Details



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.

More Details



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.

More Details



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

More Details



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).

More Details



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.

More Details



Protect Data in Tables and Queries

Version 1.5            Last updated: 22 Mar 2024

End users should only view data using forms. However, knowledgeable users may know how to circumvent basic security and access/edit/delete data from tables. This article demonstrates one way of protecting tables and queries from unwanted modification.

More Details



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

More Details



Reaction Timer

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.

More Details



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

More Details



Rounded Corners in Forms

Version 1.2            Last updated: 2 Apr 2024

This demonstrates how you can add rounded corners to forms in any version of Access. The amount of rounding can be adjusted. The effect works best with borderless forms.

More Details



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.

More Details



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

More Details



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.

More Details



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

More Details



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.

More Details



Speaking Clock

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.

More Details



SQL to VBA and back again

Version 3.42            Last updated: 18 Jul 2024

This has now been converted to an Access add-in.

It is a significantly enhanced version of my SQL to VBA And Back Again utility which makes it easy to convert query SQL to a VBA string (or vice versa). Additonal functionality includes creating example code from the VBA string and temp queries to test the SQL / VBA output.

More Details



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.

More Details



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.

More Details



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

More Details



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

More Details



System Metrics

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

More Details



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

More Details



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.
More Details



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.

More Details



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.

More Details



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

NOTE:
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

More Details



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

NOTE: This is a free cut down version of the UK Postal Address Finder app

More Details



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

More Details



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

More Details



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

More Details



View & Edit Import/Export (IMEX) Data Task Specifications

Version 2.6            Last updated: 28 May 2024

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 mainly intended for use by program admins when deploying ACCDE or ACCDB files

More Details



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)

More Details



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.

More Details



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

More Details





Return To Home Page Return To Top