Mendip Data Systems

Database applications for businesses and schools

Example Database Applications Page 1 (of 4)

To provide feedback on an example database, please enter your name, e-mail address and company (optional) below, add your comment and press the submit button. Thanks

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

Get Current Geolocation

Version 2.5 Updated 28/05/2018

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

More Details ...

Controlling the Application Interface

Version 3.0a Updated 03/01/2019

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

Currency Exchange Rate Tracker

Version 1.43 Updated 11/06/2018

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 supplied for a small fee

More Details ...

Set a group of controls as visible/hidden, enabled/disabled or locked/unlocked

Version 2.0 Updated 27/04/2017

This application demonstrates how to set various states of a group of controls at the same time using the Tag property.

More Details ...

Obtain Extended File Properties using VBA

Version 1.0 Updated 03/07/2017

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.

More Details ...

An Attention Seeking Database

Version 5.0 Updated 24/05/2018

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 & user messages

More Details ...

Measuring Reaction Times

Version 2.1 Updated 13/01/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 ...

System Tray Alerts

Version 1.5 Updated 24/05/2018

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: