Hello all,
I am designing a new database for a services customer and want to include google maps into it showing the address and route to get there. Has anyone done this and if so, how is it accomplished? I am very green on VBA.
Thanks
Dave
Hello all,
I am designing a new database for a services customer and want to include google maps into it showing the address and route to get there. Has anyone done this and if so, how is it accomplished? I am very green on VBA.
Thanks
Dave
Look at the Similar Threads at bottom of page for some ideas. Google has changed some of their policies over the years. You now need to set up a Google account and payment method for some routines, but payment only applies after some threshold is reached. See this link for more info.
Some functionality is available using Google maps in a web browser control but more can be done using the map APIs.
Further to the previous reply, you will need to setup a Google mapping account to use their APIs in your apps.
Moderate usage is free but frequent usage above the limits can quickly get expensive.
I use various APIs in several of my apps including
Get Location - http://www.mendipdatasystems.co.uk/g...ion/4594365395 (free)
UK Postal Address Finder - http://www.mendipdatasystems.co.uk/u...der/4594138311
The latter is a commercial app which has multiple features including a route planner
There is a free evaluation version but as its an ACCDE file, you won't be able to view the code.
However it may well be worth looking at anyway.
orange, Colin,
Thanks for the info. It looks like it may be a little too involved for my ability right now but may be something to look into later.
Dave