Group:  Microsoft Access ยป microsoft.public.access.adp.sqlserver
Thread: open hyperlink to asp page

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

open hyperlink to asp page
"JEM" <Jenn[ at ]JEMConsulting.org> 07.06.2006 14:46:50
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!

Re: open hyperlink to asp page
"Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> 08.06.2006 16:49:26
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


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net