importing a map to access

[Guest]

is it posible to have access search and populate a map with directrions once
an address is added to an access form?

 

[aaron.kempf]

SQL Server integrates with mappoint pretty well; I've used Analysis
Services data inside of MapPoint ActiveX controls

for other things; I'd just reccomend using a URL and either opening a
browser or using a webbrowser control

 

[Tony Toews [MVP]]

is it posible to have access search and populate a map with directrions once
an address is added to an access form?

By using Microsoft MapPoint yes you can.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

In addition to using MapPoint, here is a method that calls Internet Explorer,
using GoogleMaps:

Option Compare Database
Option Explicit

Sub GoogleMap(strStartingPoint As String, strDestination As String)

' http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1356166

' Given a FROM address and TO address, will start Internet Explorer, and
call up
' GoggleMaps to give directions with total mileage estimate!

' Example of calling from Immediate window (watch for word wrap):
' Call GoogleMap("1600 Pennsylvania Avenue, Washington, DC","9199 Office
Center Dr, Raleigh, NC 27615")

Dim strURL As String
Dim ie As Object

'Convert spaces to + sign
strStartingPoint = Replace(strStartingPoint, " ", "+")
strDestination = Replace(strDestination, " ", "+")

strURL = "http://maps.google.com/maps?f=d&hl=en&saddr=" _
& strStartingPoint & "&daddr=" _
& strDestination & "&ie=UTF8&z=5&om=1"

Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate strURL
ie.Visible = True

End Sub


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________