Google Maps API Autocomplete

[nhorton79]

Link to my code under Sample Databases:
Google Maps API Autocomplete | Access World Forums (access-programmers.co.uk)

As I have had plenty of assistance from everyone here over the years. I thought I had better post this for everyone to share.

I've been playing around with including an autocomplete address form, like you see here: Place Autocomplete Address Form | Maps JavaScript API | Google for Developers

I had initially tried doing something through html/js and then using a WebBrowser control within Access, but that was absolutely terrible. So decided I had to try and reproduce the functionality directly within Access.

Have a look. When you type in the Search box, it updates the Listbox below and makes it visible, to have the correct appearance. You can use up and down arrows to select the different suggested addresses, then press enter, or just double-click.

It utilises a session token to ensure that the multiple requests sent to Google are billed under a single session, which is cleared once the textbox registers an empty string.

All you need to do is sign up at Google for an API key and enter this. Then you can set the country restriction to keep it localised.

There are plenty of options for addresss components and how these fit your particular area. I have used this in New Zealand but you can adjust to suit your region.

Cheers

 

[DalynSoft]

I have downloaded your file and put my API key in the Public Const GOOGLE_MAPS_API_KEY declaration. I have left the country as nz. I don't get any results when I enter an address in the search field. Do you have an example of an address that works that I can check?

 

[nhorton79]

Try putting a :

Debug.Print Response.Content

inside the GeoCodeFromPlaceID function after the line Set Response = MapsClient.Execute(Request)

I just tried this from my home computer and it came up with
"This IP, site or mobile application is not authorized to use this API key. Request received from IP address xxx.xxx.xxx.xxx, with empty referer"
in the immediate window.

This is because my API key is set to work on the public IP address of our business only. You may have changed a setting when setting up your API key that restricts it somehow, so the Debug.print may help you detemine the reason your API key isn't working.

I have remoted into our workplace and run the code from there and it works perfectly. Showing any address I search for.

Hope this helps you work out where you're going wrong.

 

[DalynSoft]

Thanks - that highlighted that my API key wasn't set up for this service.