open live search map from access

Davros

Registered User.
Local time
Today, 23:54
Joined
Sep 9, 2005
Messages
131
hello
using this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=125954

i can send an address from access to open google maps and go to the location specified in one of my access fields
BUT
does anyone know how to do it using 'Live Search' located at

http://local.live.com/

I've looked at the source code but can't figure out which one of the internet address' i should use to actully send my address information to so that the map opens at the desired location.

anyone does this before?

thanks in advance
 
Last edited:
found the answer if anyones interested
if you follow the link above and the associated coding and substitute this line for the google code

"http://maps.live.com/default.aspx?where1="


then it will open live search whic his a much better aerial map then google
 
Below is what you needed for maps.live.com

Me.WebBrowser0.Document.all.Item("Where").Value = "AddressValue"
Me.WebBrowser0.Document.all.Item("searchbttn").Click
 
thanks for the reply KeithG

where would i use this code?

below is the code i'm already using with 2 unbound text boxes called "addressline1" and "postcode"

Private Sub Command32_Click()
If Not IsNull(Me!addressline1) And Not IsNull(Me!postcode) Then
Application.FollowHyperlink ("http://maps.live.com/default.aspx?where1=" & Me!addressline1 & ", " & Me!postcode)
Else
If Not IsNull(Me!addressline1) Then
Application.FollowHyperlink ("http://maps.live.com/default.aspx?where1=" & Me!addressline1)
Else
If Not IsNull(Me!postcode) Then
Application.FollowHyperlink ("http://maps.live.com/default.aspx?where1=" & Me!postcode)
Else
MsgBox ("You must have a value for the Main Address and the Postal Code in order to map the address.")
End If
End If
End If
Exit Sub
End Sub


thanks
 

Users who are viewing this thread

Back
Top Bottom