Mendip Data Systems
Database applications for businesses and schools
Example Database Applications Page 1 (of 3)
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
Controlling the Application Interface
Version 2.0 Updated 08/05/2017
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.
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 1.0 Updated 02/03/2018
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:
-
Product support or licence about to expire
-
A new version available on the application website
More Details ...
If you found this site useful, please consider giving a donation to help offset the costs in keeping it running. Thanks.
Folder Image Viewer
Version 3.0 Updated 18/04/2018
This example app shows how to show thumbnails of all images in a selected folder
More Details ...
Live Currency Exchange Ticker
Version 1.1 Updated 18/10/2018
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, shae prices, weather forecasts etc
More Details ...