If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink based on control
Hello all.
I need to set up a hyperlink on a form that starts with a web address http://maps.google.com/maps?q= and then adds two fields to the end with a space between them. I tried http://maps.google.com/maps?q=&[ShipperAddress]&" "&[ShipperZip] with no success. Any ideas? Thanks as always Mike |
#2
|
|||
|
|||
Hyperlink based on control
This is what I use.
"http://maps.msn.com/home.aspx?strt1=" & strAdd & "&zipc1=" & strZip & "&cnty1=0" Private Sub Map_Click() Dim strMap As String Dim strAdd As String Dim strZip As String strAdd = Me.Address strZip = Me.Zip_Code strMap = "http://maps.msn.com/home.aspx?strt1=" & strAdd & "&zipc1=" & strZip & "&cnty1=0" Application.FollowHyperlink strMap End Sub That's my code for a map button. the msn full web address is: http://maps.msn.com/home.aspx?strt1=1 Microsoft Way&city1=Redmond&stnm1=WA&zipc1=981052&cnty1=0 I just use street address and zip. Good Luck, Eric |
#3
|
|||
|
|||
Hyperlink based on control
Great!
Thanks wrote in message oups.com... This is what I use. "http://maps.msn.com/home.aspx?strt1=" & strAdd & "&zipc1=" & strZip & "&cnty1=0" Private Sub Map_Click() Dim strMap As String Dim strAdd As String Dim strZip As String strAdd = Me.Address strZip = Me.Zip_Code strMap = "http://maps.msn.com/home.aspx?strt1=" & strAdd & "&zipc1=" & strZip & "&cnty1=0" Application.FollowHyperlink strMap End Sub That's my code for a map button. the msn full web address is: http://maps.msn.com/home.aspx?strt1=1 Microsoft Way&city1=Redmond&stnm1=WA&zipc1=981052&cnty1=0 I just use street address and zip. Good Luck, Eric |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change background color in form based on a control value? | Mike Combe | Using Forms | 5 | March 31st, 2008 05:41 PM |
Incrementing numbers based on another control | Tracy PM | Using Forms | 1 | September 27th, 2005 01:37 PM |
Look Up Dropdown Values Based on another control | Dave K via AccessMonster.com | Using Forms | 2 | August 23rd, 2005 11:40 PM |
Change value in a control based upon another value | ken a | Using Forms | 2 | March 17th, 2005 10:03 AM |
Data Entry Mode | bdehning | Using Forms | 17 | November 22nd, 2004 04:49 PM |