Runtime error 5

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Runtime error 5

Post by Pat »

When I run the following command in VBA:
Application.FollowHyperlink rs!URL
where the rs!Url is http://www.zulutrade.com/trader/214670" onclick="window.open(this.href);return false;

I get a dialog box that spells out:
RunTime error 5
Cannot locate the Internet server or proxy server

I press F8 to go past the followhyperlink command, then press F5 to complete the job which runs to completion.
Any ideas?

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Runtime error 5

Post by Rudi »

Not sure if you have searched for this error, but I get two pages that seem to discuss and resolve it.
Test and see if it sorts your question.

-- http://www.ehow.com/how_7377896_access- ... erver.html
-- http://support.microsoft.com/kb/218153
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Runtime error 5

Post by Pat »

Yet sometimes it works fine. This is run from Access 2007 VBA.
I have seen those links and they are no help as the key they suggest to change is not there.
I can put up with doing an F8 to kick start it, then F5 to complete it.
Thanks anyway Rudi