By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,606 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Passing search parameters with hyperlink to an ASP page

P: n/a
Hi there,

The website has an ASP page and I want to pass parameters within the
URL using Access 2003.

I have the format of the URL worked out. If this is pasted into the
address bar of IE, it works exactly as required.

When I use the FollowHyperlink method in VBA using the same string, it
does not work properly. Very strange, and it has got me beat.

The structure of the URL is (with IP address changed)

http://123.123.123.123/DMS/FindFile....FileWanted.pdf

The parameters being passed log the user onto the site and pass in a
string for a search function to display the requested file. This string
works perfectly if simply pasted into the IE address bar. However, when
called with FollowHyperlink, the user is logged in, and then thrown out
again. This could be something to do with the ASP coding, but it is not
my site, so I cannot change it, or it would be difficult to get it
changed.

Is there any other way to use Access 2003 to open IE and follow a URL
other than use Follow or FollowHyperlink?

Any help appreciated.

Cheers, Paul

Jan 5 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Curious_Kiwi wrote:
Hi there,

The website has an ASP page and I want to pass parameters within the
URL using Access 2003.

I have the format of the URL worked out. If this is pasted into the
address bar of IE, it works exactly as required.

When I use the FollowHyperlink method in VBA using the same string, it
does not work properly. Very strange, and it has got me beat.

The structure of the URL is (with IP address changed)

http://123.123.123.123/DMS/FindFile....FileWanted.pdf

The parameters being passed log the user onto the site and pass in a
string for a search function to display the requested file. This string
works perfectly if simply pasted into the IE address bar. However, when
called with FollowHyperlink, the user is logged in, and then thrown out
again. This could be something to do with the ASP coding, but it is not
my site, so I cannot change it, or it would be difficult to get it
changed.

Is there any other way to use Access 2003 to open IE and follow a URL
other than use Follow or FollowHyperlink?

Any help appreciated.

Cheers, Paul


I seem to remember having success doing what you're trying in the past.
Did you escape any/all spaces characters?
Jan 5 '06 #2

P: n/a
Thanks for the reply. I have not used any escape codes.

There are no spaces at all and no other characters requiring escape
codes as far as I can see. The only ones that I understand are
necessary are the chracters & > <

Should I escape the whole thing?

I am just baffled that a string pasted into the browser dirctly behaves
differently to a string using FollowHyperlink.

Cheers, Paul

Jan 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.