• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

UK Postcode Address & House Price Lookup (1 Viewer)

Status
Not open for further replies.

isladogs

CID VIP
Local time
Today, 13:17
Joined
Jan 14, 2017
Messages
13,955
Attached 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 application UK Postal Address Finder



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 info(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

In order to use the app, you will need to enter a valid Google maps API key (one with billable info)



The 2 zip files attached contain 32-bit & 64-bit ACCDE versions of the application (These are both executable files so no source code available)
An ACCDB version with full source code can be purchased at a reasonable price from my website: http://www.mendipdatasystems.co.uk/uk-postcode-address-lookup/4594767232
 

Attachments

  • MainForm.jpg
    MainForm.jpg
    99.2 KB · Views: 417
  • APIForm.PNG
    APIForm.PNG
    43.2 KB · Views: 420
  • PostcodeAddressLookup32.zip
    278.7 KB · Views: 87
  • PostcodeAddressLookup64.zip
    242.2 KB · Views: 67
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom