[AccessD] Access Address to Map in Browser

Yep, but I'm afraid it uses the Map24.Com website which is good for Europe
but not the US. I have a country table which holds the Map24 country code
(some differ from mine) in CT_MAPCODE. So I pass the routine my country code
and the Postal Code and, optionally, a description (eg company name) which
appears at the top of the map. It then plugs this info into the Map24
plotting URL and bob's your uncle.

FWIW here's the function (watch the wrapping):

Function MapIt(strCountry As String, varPcode As Variant, Optional varDesc
As String)
Dim varMapCode As Variant
Dim strLink As String

If Not IsNull(varPcode) Then
varMapCode = DLookup("CT_MAPCODE", "CTRY", "CT_CODE='" & strCountry & "'")
If Not IsNull(varMapCode) Then
strLink = "http://link2.map24.com/?lid=0cb4a937&maptype=JAVA&street0=&zip0="
& varPcode & "&city0=&country0=" & varMapCode & "&description0=" & varDesc &
"&lang=en"
Call RunApp(strLink, 1)
End If
End If
End Function

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: [AccessD] Access Address to Map in Browser
Date: 27/04/04 10:53

>
> Group
>
> ....in Outlook, I can  open a map of a contact's address in a browser
> directly from Outlook as follows:
>
> a) select Contacts on the Outlook Bar or in the folder list.
> b) select contact whose address I want to locate.
> c) File/Open/Selected Items.
> d) Under the Address button, click the arrow, and then click the type of
> address I want to find on the map (Business/Home/Other).
> e) Actions/Display Map of Address.
>
> ....my browser opens to Find a Map at mappoint.msn.com with a push-pin
> marking the location of the address.
>
> ....has anyone done anything like this via code from Access? ...without
using
> Outlook?
>
> William Hindman
> "Always code as if the person who is maintaining or testing your code
is
> a violent psychopath who knows where you live." William Silverstein
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2