Version 1.2           First published 25 July 2018           Approx 0.8 MB

Please see the IMPORTANT UPDATE below

This is a free example 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 in his excellent article: Geocoding using VBA & Google API
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 192.com

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 in/out (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 (with billable info). This is required in order to use the app.




Downloads

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

UK Postcodes Address Lookup  (32-bit ACCDE)

UK Postcodes Address Lookup  (64-bit ACCDE)



Purchase

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 (but see important update below).

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



IMPORTANT UPDATE - 7 Nov 2023

It was brought to my attention recently that 192.com recently blocked remote access to their data.
As a result, this application does not currently work and it is HIGHLY UNLIKELY that it will work again in the future.

The code still opens the correct URL but results in an Address Not Found error. Further investigation shows this is caused by HTTP status code 403.

The HTTP 403 Forbidden response status code indicates that the server understands the request but refuses to authorize it.
This status is similar to 401, but for the 403 Forbidden status code, re-authenticating makes no difference.
The access is tied to the application logic, such as insufficient rights to a resource. For more info, see 403 Forbidden

Unfortunately, I don’t believe anything can be done to overcome the ‘firewall’ that has been imposed by 192.com. It is their data and they have every right to restrict access.

Possible alternatives include:
1.   Go to the 192.com website to get the addresses (currently free)
2.   Pay 192.com for a number of searches (very expensive)
3.   Pay for another address provider service e.g. Royal Mail or Ideal Postcodes.
4.   Ideal Postcodes address data can be used with my much more powerful UK Postal Address Finder app also available from this website.



Feedback

Please use the contact form below to let me know whether you found this article interesting/useful or if you have any questions/comments.

Please also consider making a donation towards the costs of maintaining this website. Thank you



Colin Riddington           Mendip Data Systems                 Last Updated 7 Nov 2023

Return to Example Databases Page

Return to Top