Possibility to ByPass Hyperlinks Warning

[Kenny G]

Is there a way to by pass a hyperlinks warning message in an Access form?
Each time a user clicks on a hyperlink a warning comes up telling the user
that is could be harmful to their computer.

Access 2003

 

[Klatuu]

I use the api code from this site:
http://www.mvps.org/access/api/api0018.htm

 

[Kenny G]

Klatuu,

I got the code from your posting. At which location to I place the code?
Under the form?

 

[Klatuu]

No, the code should go in a standard module by itself.

Here is the line from one of my apps where I use it:
Call fHandleFile(strhyperlink, WIN_NORMAL)

 

[Kenny G]

Klatuu,

I've created a mod called "modfHandleFile" and pasted the contents in the
module.

in the text box on the form I have placed the following code:

Private Sub Current_Click()
Call fHandleFile(Current, WIN_NORMAL)
End Sub

When I click the textbox I get the same message.

Ken

 

[Klatuu]

Don't know why. It works for me.
Can you post the content of Current

 

[Kenny G]

Klatuu,
The control is a textbox called Current on the form "frmDataView" and the
Control Source is Current (a field in the underlying table called
"tblpolicyreview.") I put the hyperlink on the form where the field Control
is located.

The Access DB and the .docs and .pdfs are on the network in the same folder.

I don't know if I have given you what you have requested.

Thanks,

 

[Klatuu]

I was hoping for an example or two of the content of the control.

 

[Kenny G]

Klatuu,

They look like this: "01-01.04.doc" or "02-01.05.pdf"

 

[Klatuu]

I don't know. I know I was getting the error when I first tried to use a
hyperlink and was advised to use the code to which I referred you and it
cured it for me.

I just ran some testing, and don't get the problem. I put a .doc file in
the folder with my mdb and passed only the file name and it worked.

I guess it could be related to the Windows firewall settings, but I don't
really know. You might check with your network or security people.

 

[Kenny G]

Klatuu,

Many thanks! I'll speak to them this afternoon.

 

[Klatuu]

Okay, Kenny. I also posted the question in a location other MVP's use.
Maybe one of them can help. If I get a response, I'll let you know.

 

[Klatuu]

Are you on XP or Vista?
Is the file located on an untrusted site (network drive addressed by IP)?

Also, here is a registry hack that may cure the problem:
http://support.microsoft.com/kb/829072

 

[Klatuu]

Also, try doing it with the doc but without the pdf.
I am hearing the pdf files can be a problem with the warnings.