Can you map geographical locations in a contact database?

  • Thread starter Thread starter tony_1199
  • Start date Start date
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
 
Yes with auxiliary software such as MapPoint. You can also store addresses
and latitude/longitude information in a database for mapping with other
programs.
 
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.
 
Back
Top