Hyperlink Security Warning

[billgyrotech1]

Hello,

I have Access 2013 and in my Main Form I have hyperlinks to network drawings. When clicking on the hyperlinks I get the warning message :



"A potential security concern has been identified......

This location may be unsafe.


Can someone please figure out how to disable this annoying popup message?

Thank you very much for your help,
Bill

[June7]

Instead of Hyperlink field, use FollowHyperlink method in code.

An Access hyperlink is composed of 3 parts separated by # character. You need to extract middle part to use with FollowHyperlink.

[billgyrotech1]

Thank you for responding but I don't understand can you please elaborate?

I was using the Hyperlink Address and browsed for the file locations.

[June7]

What exactly did you not understand?

If you have a Hyperlink type field in table, then those values have a 3-part structure. Review: http://allenbrowne.com/casu-09.html

Alternative is to use FollowHyperlink method.

More info: http://allenbrowne.com/func-GoHyperlink.html

[billgyrotech1]

I have command buttons to open the file drawings

[billgyrotech1]

I sort of have it working:

Private Sub Command9_Click()
Application.FollowHyperlink "U:\Old User FIles\REPAIR STATION\RSM-QCM 000"
End Sub

But it doesn't open the Word Document called "RSM-QCM Revision C"

I tried to add that but it gives an error.

Is there a special format to open the document?

[billgyrotech1]

Thanks June I got it to work.