HYPERLINK QUESTION

[Developerme]

With a hyperlink, I want to travel to website and then automatically put in a
field that exists in Access database. This is the code I have (which doesn't
work);

Address = Replace(Streetaddress, " ", "%20")
Application.FollowHyperlink
"http://www.zillow.com/search/Search.htm?addrstrthood[Address]), , True,
False"

The hyperlink will not recognize the filed ([Address]). Can someone provide
me with some direction on what I am missing in the code, please?

 

[Daniel Pineault]

Try something more like:

Address = Replace(Streetaddress, " ", "%20")
Application.FollowHyperlink
"http://www.zillow.com/search/Search.htm?addrstrthood" & Address), , True,
False"

1. Would you not need an = after addrstrthood?
2. Where is Streetaddress coming from? If from a form you may need to try
something more like:
Address = Replace(Me.Streetaddress, " ", "%20")
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[David C. Holley]

You cannot pass values to a page to be filled into controls in a FORM tag.
While a querystring can be used to send values to the web server, the page
has to be expecting them. If the page does not have any code-behind,
javascript or other code in any language, the querystring is simply a string
that's passed through. Its the code that takes the string and works with it
and the parameters have to match what the code is expecting. For example, if
the page is expecting a queryparameter named Id as in
www.gatewayorlando.com/ratequote.aspx?Id=1000 and you supply Product Number
as in www.gatewayorlando.com/ratequote?productnumber=1000 nothing will
happen, althought the page will still be processed.

Try something more like:

Address = Replace(Streetaddress, " ", "%20")
Application.FollowHyperlink
"http://www.zillow.com/search/Search.htm?addrstrthood" & Address), , True,
False"

1. Would you not need an = after addrstrthood?
2. Where is Streetaddress coming from? If from a form you may need to try
something more like:
Address = Replace(Me.Streetaddress, " ", "%20")
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

With a hyperlink, I want to travel to website and then automatically put
in a
field that exists in Access database. This is the code I have (which
doesn't
work);

Address = Replace(Streetaddress, " ", "%20")
Application.FollowHyperlink
"http://www.zillow.com/search/Search.htm?addrstrthood[Address]), , True,
False"

The hyperlink will not recognize the filed ([Address]). Can someone
provide
me with some direction on what I am missing in the code, please?