asked on
Obtaining coordinates using google maps with MS Access
I have tried the different ways of launching IE from MS Access to allow the user to view a Google map and that works fine. Is there any way to retrieve in MS Access the lat/long coordinates that the user points to, assuming he/she may change the location after viewing the map? I have a Google Map API key, but don't know how I could get the coordinates. If this is not possible, could I pass and address to an API from MS Access and have the API return either an error code or the coordinates?
Thanks!
Thanks!
Microsoft Access
Last Comment
beehilly
ASKER
Thank you for your help, but I need programmatic options. Any out there?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
i realized i had my lat a long switched - so i fixed that and made the code a little better. here you go
MYGoogle.accdb
MYGoogle.accdb
ASKER
This is working exactly how I wanted it to work. Thank you SO much.
1: right on a location on the map select one of the options such as "Whats here?"
then in the bottom left corner of the page the coordinates will appear.
2: the other way i found is to get a link for the current location click on "link" next to print and send a box will appear with the link.
hope this helps
c1.bmp
c2.bmp