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.

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

http://code.google.com/apis/maps/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"YorksTopBear" <(E-Mail Removed)> wrote in message
news:6842DCA5-3E0E-4F70-8451-(E-Mail Removed)...
>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

"Arvin Meyer [MVP]" wrote:

> Google has a mapping api that may be able to help:
>
> http://code.google.com/apis/maps/
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "YorksTopBear" <(E-Mail Removed)> wrote in message
> news:6842DCA5-3E0E-4F70-8451-(E-Mail Removed)...
> >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.
>
>
> .
>

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

"YorksTopBear" <(E-Mail Removed)> wrote in message
news:6842DCA5-3E0E-4F70-8451-(E-Mail Removed)...
> 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.

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

"YorksTopBear" <(E-Mail Removed)> wrote in message
news:E0417964-5036-4F28-A64E-(E-Mail Removed)...
> 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
>
> "Arvin Meyer [MVP]" wrote:
>
>> Google has a mapping api that may be able to help:
>>
>> http://code.google.com/apis/maps/
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>>
>> "YorksTopBear" <(E-Mail Removed)> wrote in message
>> news:6842DCA5-3E0E-4F70-8451-(E-Mail Removed)...
>> >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.
>>
>>
>> .
>>

"Philip Herlihy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com