Application.FollowHyperlink

[Trilback]

I have a access db that has a Map address button on my forum. That when I hit it, it will map the address from the forum I have. Think I did something wrong. See below:


Forum boxes names,

Address_Line_1
City
StateProvince
ZIPPostal


ex address.
19738 Germantown Rd
Germantown, MD 20874

If I type this into my web browser it does work but dunno why my code does not.

https://www.google.com/maps/place/19738 Germantown Rd,+Germantown,+MD,+20874/

Here the code but its not working right.

Application.FollowHyperlink "https://www.google.com/maps/place/" & [Me.Address_Line_1] & ",+" & [Me.City] & ",+" & [Me.StateProvince] & ",+" & [Me.ZIPPostal] & "/"

HELP!!!!

 

[Eljefegeneo]

I have been using this with success, and also I will not take any credit for it. But it works for me.

Dim strURL As String
strURL = "http://maps.google.com/maps?q=" & Me.Address & ",+" & Me.City & ",+" & Me.State & "+" & Me.ZIP4 & ", +" & Me.COUNTRY
Application.FollowHyperlink strURL

 

[Trilback]

I have been using this with success, and also I will not take any credit for it. But it works for me.

Dim strURL As String
strURL = "http://maps.google.com/maps?q=" & Me.Address & ",+" & Me.City & ",+" & Me.State & "+" & Me.ZIP4 & ", +" & Me.COUNTRY
Application.FollowHyperlink strURL

Thanks that worked great

 

[Eljefegeneo]

Just so you know, that was the first time I posted something to help someone. I am usually in great need of help. Glad I could be of assistance. I should have mentioned that somehow with the fields that I have on my DB, I can even bring up most European addresses.