Acess DB - list of worldwide contacts - can I show them on a map?.

[YorksTopBear]

I have created an Access DB showing a list of over 150 contacts worldwide.
What would be ideal, to show them to the boss, would be to plot the cities
against a map and reference them with a numbered flag relating to the
corresponding record. Can this be done? Please Help.

 

[Arvin Meyer [MVP]]

Google has a mapping api that may be able to help:

http://code.google.com/apis/maps/

 

[YorksTopBear]

Thanks, Arvin. If I've understood correctly, I can only use this if I have a
website, is that correct? I am quite conversatn with Word, Excel and
PowerPoint but Access is something that is very new to me - very plain
English for the stupid is very much appreciated . Is there a way I can do
this without a website? Can I ask Access to look in a particular column and
give a reference from another column that show as a pin or flag on the map?

Thank you, again, Alvin, for your response.

Kind regards

Michael

 

[Philip Herlihy]

MapPoint can do this.

http://www.microsoft.com/mappoint/en-us/default.aspx

There's a free trial, so you could impress your boss enough to get him to
pay for a license (about £250, new version out at the end of this month).
Autoroute will do something similar - if you're in the US the equivalent is
called something like "Streets and Trips". Autoroute was discontinued after
2007.

Phil, London

 

[Arvin Meyer [MVP]]

Well there is another way, and I have done some rudimentary work with it.
Microsoft MapPoint has a VBA object model and is fully programmable in
Access. I have been able to put a pushpin on a imported map and show the
directions. I have not tried anything like what you desire, but I suspect it
could be done. Try asking this question in a MapPoint newsgroup. There are a
few MVPs there with possibly more expertise in that area than I have in
MapPoint.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

MapPoint can do this.

http://www.microsoft.com/mappoint/en-us/default.aspx

There's a free trial, so you could impress your boss enough to get him to
pay for a license (about £250, new version out at the end of this month).
Autoroute will do something similar - if you're in the US the equivalent
is called something like "Streets and Trips". Autoroute was discontinued
after 2007.

Phil, London

I'm pretty sure that Streets & Trips (and probably AutoRoute) do not have a
programmable object model.