Can you map geographical locations in a contact database?

U

UpRider

Tony here's a click event that will show a Mapquest map...

Private Sub cmdMap_Click()
Dim strParam As String
Dim strPre As String
Dim strSuf As String
Dim strLink As String
Dim addr1Work As String
addr1Work = Replace(myADDR1, " ", "+")
strPre = "http://www.mapquest.com/maps/map.adp?"
strSuf = "&country=US&cid=lfmaplink"
strParam = "address=" & addr1Work & "&City=" & myCITY & "&state=" & myST
& "&zipcode=" & mytxtZipAlias
strLink = strPre & strParam & strSuf
'Debug.Print strLink

Me.cmdMap.HyperlinkAddress = strLink

End Sub

Replace all the myxxxxxxxx with your fieldnames...
HTH, UpRider
 
A

Arvin Meyer [MVP]

Yes with auxiliary software such as MapPoint. You can also store addresses
and latitude/longitude information in a database for mapping with other
programs.
 
M

Mark Andrews

You can also do things like throw all your contact addresses on a google
map. You just need the html file and some code.
I know utteraccess has some google mapping examples. Give me an email if
this is what you want and you can't find anything.
 
Top