Open google maps in access

frimy
frimy used Ask the Experts™
on
Hi All,

I use this code to open Google maps in access, it works very good it opens Google maps with the destination address,
I would like to know if its possible also to send in the from location into Google maps and it should open Google with the from and to location.    

    Dim wAdrs As String
    wAdrs = Me.Address1 & " " & Me.Address2 & " " & Me.City & " " & Me.State & " " & Me.ZipCode
    Me.DirBT.HyperlinkAddress = Switch(Nz(wAdrs, "") <> "", "http://www.google.com/maps?q=" & wAdrs, True, "")  

Thanks advance
Frimy
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ferruccio AccalaiSenior developer, analyst and customer assistance

Commented:
you could use
http://maps.google.com/maps?saddr=YourStartAddress&daddr=YourDestinationAddress

Open in new window

Author

Commented:
Thanks for your help
it works

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today