Disabling a hyperlink message in Access

B

Bonitae

I have a field in my database that is a hyperlink to a PDF and everytime I
click on the hyperlink to access the PDF I get a security warning that says:

"Hyperlinks can be harmful to your computer and data. To protect your
computer, click only those hyperlinks from trusted sources. Do you want to
continue?"

How can I disable this warning?
 
V

Van T. Dinh

Try changing the Macro Security setting to Low ...

I am not sure which method you used (it sounds like you use Hyperlink
Fields) but in my case, I use Application.FollowHyperlink and I don't get
the warnings with Macro Security set on Low.
 
B

Bonitae

Thanks, but I did check the Macro Security setting and it is set on low. I
did use the method you mentioned. However, I am not sure how you set yours,
can you walk me through it?
 
V

Van T. Dinh

I don't use Hyperlink Field. The full pathname to the PDF file is
constructed from different components in my database and once I constructed
the full pathname, I simply use:

Application.FollowHyperlink "file:" & FullPathName"

For example it may resolve to something like:

Application.FollowHyperlink "f i l e
:\\HOSBTSVR\Products\PDFs\P10001.pdf"

(remove the spaces in file as if I don't use spaces, OutlookExpress converts
it to a hyperlink automatically)
 
B

Bonitae

Sorry, I am still a novice at Access. Can you wlak me through this step by
step. I already have the database set up and maintain the PDF files on a
public drive. Can the table be modified to do what you are suggesting and if
so, can you just give me step by step instructions? Thanks!
--
Bae


Van T. Dinh said:
I don't use Hyperlink Field. The full pathname to the PDF file is
constructed from different components in my database and once I constructed
the full pathname, I simply use:

Application.FollowHyperlink "file:" & FullPathName"

For example it may resolve to something like:

Application.FollowHyperlink "f i l e
:\\HOSBTSVR\Products\PDFs\P10001.pdf"

(remove the spaces in file as if I don't use spaces, OutlookExpress converts
it to a hyperlink automatically)
 
V

Van T. Dinh

Not in Table. Tables don't have any Event exposed so that you can use as
trigger for your code to be executed. You need to use a Form.

Also note that I wrote previouslt that I didn't use the Hyperlink Field.
The relevant field is simply a Text Field storing the full pathname of the
file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top