Hyperlink Warning Message

[jkjmwilliams]

I have hyperlinks to files in my database. When I click on them, it gives me
this annoying error message about how hyperlinks can be dangerous. How can I
disable that warning?

JoAnn

 

[Allen Browne]

JoAnn, see:
GoHyperlink() - Handle warnings, special characters, and errors
at:
http://allenbrowne.com/func-GoHyperlink.html

Have been going to write that for ages, since it affects so many people.
Your post was the trigger today.

 

[jkjmwilliams]

JoAnn, see:
GoHyperlink() - Handle warnings, special characters, and errors
at:
http://allenbrowne.com/func-GoHyperlink.html

Have been going to write that for ages, since it affects so many people.
Your post was the trigger today.

 

[jkjmwilliams]

I used this code and couldn't get past the first step in the debugger. I'm
kind of confused about this. This hyperlink is in a dababase named
cookbook.mdb.The database and all the Word documents (recipes) and are in a
folder called MyRecipes, and then the usual path on my computer.

In the code:
Public Function PrepHyperlink(varIn As Variant, Optional strErrMsg As
String) As Variant

what should I use as Variant?

I'm a novice at code writing, but have a little familiarality and knowledge
of it. Is this too advanced of a proceedure for me? Or can you walk me
through this?

JoAnn

 

[Allen Browne]

Use the fully qualified path. For example, if your "usual path" is
C:\Users\jkjmw\AppData\Roaming\
and it's the folder named MyRecipies, open the Immediate Window (Ctrl+G) and
enter:
?
PrepHyperlink("C:\Users\jkjmw\AppData\Roaming\MyRecipies\cookbook.mdb")

You should get the response:
file:///C:/Users/jkjmw/AppData/Roaming/MyRecipies/cookbook.mdb

If that works, use:
GoHyperlink "C:\Users\jkjmw\AppData\Roaming\MyRecipies\cookbook.mdb"

It is the prepending of file:/// that is aimed at averting the security
warning.