open hyperlink to asp page

J

JEM

Hi. I am trying to open a hyperlink through code to a redirected asp
page but it is not working. Here is a portion of my (revised) code:

Dim strsql as string
strsql = "http://dev.companyname.com/submitpayment/Redirect.asp"
Application.FollowHyperlink strsql, , True, , "id=2"

I have also tried not using the 'extra info' portion:

Dim strsql as string
strsql = "http://dev.companyname.com/submitpayment/Redirect.asp?id=2"
Application.FollowHyperlink strsql

Each time, Internet Explorer opens, but it drops the id, the 2, so it
doesn't bring up the data form. If i manually type in the url into a
browser window it works fine, but when the hyperlink is sent from my
code it doesn't work. I also tried disabling my firewall to see if that
had something to do with it but i saw no changes. Any ideas?
Thanks!
 
V

Vadim Rapp

J> Dim strsql as string
J> strsql = "http://dev.companyname.com/submitpayment/Redirect.asp?id=2"
J> Application.FollowHyperlink strsql

J> Each time, Internet Explorer opens, but it drops the id, the 2, so it
J> doesn't bring up the data form.

I tried

Application.FollowHyperlink "http://www.google.com/search?q=bubba"

and it worked OK. But it's possible that Access is trying to be "helpful"
and intervenes somehow. Here's another, more universal way of doing it:


CreateObject("wscript.shell").Run "http://www.google.com/search?q=bubba"

Vadim Rapp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top