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

  • Thread starter Thread starter YorksTopBear
  • Start date Start date
Y

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.
 
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
 
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
 
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
 
Philip Herlihy said:
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
Click to expand...

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