Mendip Data Systems

Database applications for businesses and schools

LogoTransparent

Version 1602      Updated 13/02/2016               Approx 0.9 MB

 

This is used to test sending emails directly from Access without using Outlook.

 

If there are issues, error messages are displayed to assist with fixing the problem(s)

 

Click to download:  EMail Tester

emailtester2 emailtester3

EMail Tester  

Student ICT database

Click any image to view a larger version ...

StudentICTDatabase EmailTester StudentICTDatabase2

Version 1602     Updated 05/04/2016               Approx 1.3 MB

 

This can be used to display remaining time during timed student tasks

A choice of alarm sounds are available to indicate when countdown time has completed

 

Click to download:  Countdown Timer

Countdown Timer

Countdown Timer1 Countdown Timer2

Screenshots

UK Postcode Address & House Price Lookup

Version 1.2     Updated 08/12/2019               Approx 0.8 MB 

 

This is a simple app I created 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

 

It is a cut down version of my commercial UK Postal Address Finder application.

 

The geocoordinates for the postcode are obtained using code similar to that by Christos Samaras at https://myengineeringworld.net/2014/06/geocoding-using-vba-google-api.html

The site has a lot of useful code for Access and other platforms

 

The address and house price data (where available) is extracted from freely available data downloaded from https://www.192.com/places/

 

The static Google map includes a marker indicating the postcode centre.

The map can be modified in various ways:

a)   nudged up/down/left/right

b)   zoomed on a 1-20 scale) where the default = 17

c)   the map style can be altered (roadmap/terrain/satellite/hybrid) with default =hybrid

d)   a full screen 'live' map can also be loaded

 

When the app is first loaded, you will be prompted to enter a valid Google maps API key (one with billable info). This is required in order to use the app.

 

Click to download an ACCDE version of the app for 32-bit/64-bit Access:

CERT Version 1.43

Return to Example Databases Page

Example Apps for Businesses, Schools & Personal Use

PostcodeLookupAPIForm PostcodeLookupMainForm

UK Postcodes Address Lookup  (32-bit ACCDE)

 

UK Postcodes Address Lookup  (64-bit ACCDE)

NOTE: 

This application is supplied free as an Access 'executable' file (ACCDE)

This means that program code is NOT available for viewing.

 

If you would like full access to the program code, this can be purchased at a reasonable price.

 

An ACCDB file will be supplied with full program code so you can enter your own data, modify the application or use parts of it in your own applications.

 

Click to purchase:  Full Source Code

home