UK Postcode Address & House Price Lookup (1 Viewer)

Status
Not open for further replies.

isladogs

CID VIP
Local time
Today, 06:08
Joined
Jan 14, 2017
Messages
14,028
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: 447
  • APIForm.PNG
    APIForm.PNG
    43.2 KB · Views: 439
  • PostcodeAddressLookup32.zip
    278.7 KB · Views: 97
  • PostcodeAddressLookup64.zip
    242.2 KB · Views: 76
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom