Mapping Tools I Can Use With Access

[John Big Booty]

Re: Mapping Tools I Can Use With Access AWESOME!

...

Finally - can more than one waypoint be viewed at a time?

Sorry for the delay No it's not possible to easily open Google maps to show multiple waypoints, this would require a fair bit of Java script, I'm told. However what should be fairly straight forward would be to create a KML file with all the way points you wish to show, and then open that in Google Earth. Good luck and have fun

Oh and let us know how you go.

 

[ChrisO]

You may be able to use some of the code in the attachment.

Regards,
Chris.

 

[John Big Booty]

Thanks Chris that looks good. I've not had a chance to delve into it and see what makes it tick just yet. But will do as soon as I get a spare moment.

 

[Davros]

hi guys
I had this problem once and had this solution posted to me.
basically you have a form with 2 unbound boxes - 1 called 'addressline1' and the other called 'postcode' . this code you then stick behind a command button on the 'onclick' event:

Private Sub cmdgetdirections_Click()
'Edit the address subform for a contact (fsubContactOverviewPage4)
'Add a button at the top called "cmdMapIt" with caption "Map It!"
'Add the following code behind the button's OnClick event:
' {code}
If Not IsNull(Me!addressline1) And Not IsNull(Me!Postcode) Then
Application.FollowHyperlink ("http://maps.google.com/maps?f=q&hl=en&q=" & Me!addressline1 & ", " & Me!Postcode)
Else
If Not IsNull(Me!addressline1) Then
Application.FollowHyperlink ("http://maps.google.com/maps?f=q&hl=en&q=" & Me!addressline1)
Else
If Not IsNull(Me!Postcode) Then
Application.FollowHyperlink ("http://maps.google.com/maps?f=q&hl=en&q=" & 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
' {code}
Exit Sub
End Sub


hope this helps

 

[kmb]

The last reply works perfectly...thanks very much