isladogs
MVP / VIP
- Local time
- Today, 08:20
- Joined
- Jan 14, 2017
- Messages
- 18,538
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
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
Last edited:
