Microsoft Access - Google Maps Basics

[@naungsai]

Thank you very much for this tutorial.
I like it.

[@DanielPineault]

You're most welcome.

[@nicholasyelle497]

Great video. Is there any way to put multiple address in the same map view?

[@DanielPineault]

For that you need to have a google account and use the API.

[@ibn-nafis3434]

Thanks, can we use map while offline?

[@DanielPineault]

If it's loaded and you disconnect it remains in display, but if you try and scroll you'll get nothing.
It's basically the same as on a cellphone. These are online tools that basically require internet connection to work.

[@QaSZka]

Great tutorial👍 maybe you know how to hide the sidebar using vba?

[@DanielPineault]

Sadly, Google never provided the means to hide it. MANY people complained, but they never gave a button or exposed the means to do so. You could review the HTML/CSS and try to manipulate things via Javascript/jQuery if you really wanted to eliminate it, but based on past review of Google content they never make overriding things easy.

[@sager014]

Thanks Daniel for the informative video, it's very helpful.
One question: Can i use a similar approach to pin a location on google maps and then it auto-populate the Latitude and Longitude values in a form? any ideas?

[@DanielPineault]

Actually, yes, you can display the map of an address, and when Google processes it, it then include the geolocation in the new url. So we could simply extract it from the URL. I'll see if I can put some sample code together.

[@DanielPineault]

I've updated the article and demo to include and example of extracting the latitude and longitude when mapping an address.

[@sager014]

@@DanielPineault That is awesome!!
Thank you Daniel

[@mrrcomp]

Excellent Video

[@DanielPineault]

Thank you very much.

[@mrrcomp]

@@DanielPineault Thanks for your swift response... I downloaded the Demo File and did the hkey hack tried several different options on the hkey value but it keeps giving me the script errors .
Suggestions?
Meir

[@DanielPineault]

Sadly this no longer works with the Old Web Browser control as Google has updated its libraries making IE no longer supported ( groups.google.com/g/google-maps-js-api-v3-notify/c/l3mdkZ5JyDg?pli=1 ). So the only way to use Google Maps is via the 'new' Modern Web Browser control. I will have a video on this shortly.

[@eymardemis-hiversegna2585]

I'm trying to run the access file with MS2019, but I'm getting an error message. update browser. How can fix it ?

[@DanielPineault]

I'm afraid I do not have a system built with 2019 on it.
I know over the years Google has been increasing the minimum requirements to run sites. It is possible because this used the old web browser control that it can no longer be used. The solution may be to switch over to using the new modem web browser control. But this is just my best guess at this point in time.

[@eymardemis-hiversegna2585]

thanks a lot

[@muhammadasadkhan3466]

How can we get the longitude and latitude automatically based on where we are and then convert it into an address

[@DanielPineault]

You'd have to use a location service for that or use Google maps to lookup the address and extract the coordinates.
There may be a way to use some web automation to query the browser to get the information.

[@dbdata9836]

Great dear:

[@DanielPineault]

Thank you.

[@dbdata9836]

thanks

[@DanielPineault]

You're most welcome.

[@vpugliese33]

Very nice. Tks.!!

[@DanielPineault]

My pleasure, glad you liked it.

[@fatvmusic8853]

Muy excelente

[@DanielPineault]

Gracias.

[@robby-ke8040]

Fantastic

[@DanielPineault]

Glad you liked it.