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?
Runtime error 5
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Runtime error 5
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
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: Runtime error 5
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
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