esidb
09-02-2008, 09:20 AM
Hello! I'm looking to create a google map link from a table- the table will have numerous entries that will all need to be added to the google map. Fields (for example) are address, city, state, zip and I'm looking to create the map through a form button with vba code. If someone could tell me how to go about this, I would greatly appreciate it. Thanks so much...
Banana
09-02-2008, 09:39 AM
ChrisO, a poster here, has made an excellent sample which you can find by searching in our Sample Database forum.
esidb
09-02-2008, 09:55 AM
Thanks for that- I downloaded that database, but in reviewing it, I noticed that it's pulling just two addresses from the open forms as the start/end address. How would I go about mapping the entire table. My application creates a route- which has several stops on it. I just need to create markers for each location. Any ideas?
Banana
09-02-2008, 10:04 AM
My suggestion would be to rip that sample database to pieces, and find out what APIs are being used to get the route, and look on web for API documentations which will then give you the information on which functions you need to call to create a route and/or markers as necessary.
ChrisO
09-02-2008, 08:56 PM
It can be done and it’s not all that difficult.
But it could become a contentious issue in that it might contravene the Google Maps™ ‘Terms of Service’ in their, but not limited to, tracking clause… if I remember it correctly.
As Banana suggests, a search of the www will produce your requirements when trying to concatenate destination addresses to produce waypoints.
Regards,
Chris.