Hello
With help from this forum I've coded this in access2007 to open google street view based on the postcode field. It opens the correct address in google (by that I mean google displays the address as text and the correct postcode is in the search bar) but the streetview image itself is of a different property! I know I've probably mis-placed my strGoogleLocation but not sure where! Can someone point me in the right direction please?
Private Sub MapSearch_Click()
Dim MyHyperlink As String
Dim strGoogleLocation As String
strGoogleLocation = Replace([Postcode], " ", "+")
MyHyperlink = "https://maps.google.co.uk/maps?q=q&hl=en&geocode=&time=&date=&ttype=&q=" & strGoogleLocation & "&hl=en&ll=55.594158,-4.44425&spn=0.000003,0.002057&om=0&hnear=strGoogleLocation,+United+Kingdom&t=h&z=19&layer=c&cbll=55.594158,-4.44425&panoid=A-wU1oMwJ072GwX_rLWofQ&cbp=12,341.58,,0,0"
Application.FollowHyperlink MyHyperlink
End Sub
With help from this forum I've coded this in access2007 to open google street view based on the postcode field. It opens the correct address in google (by that I mean google displays the address as text and the correct postcode is in the search bar) but the streetview image itself is of a different property! I know I've probably mis-placed my strGoogleLocation but not sure where! Can someone point me in the right direction please?
Private Sub MapSearch_Click()
Dim MyHyperlink As String
Dim strGoogleLocation As String
strGoogleLocation = Replace([Postcode], " ", "+")
MyHyperlink = "https://maps.google.co.uk/maps?q=q&hl=en&geocode=&time=&date=&ttype=&q=" & strGoogleLocation & "&hl=en&ll=55.594158,-4.44425&spn=0.000003,0.002057&om=0&hnear=strGoogleLocation,+United+Kingdom&t=h&z=19&layer=c&cbll=55.594158,-4.44425&panoid=A-wU1oMwJ072GwX_rLWofQ&cbp=12,341.58,,0,0"
Application.FollowHyperlink MyHyperlink
End Sub
