How do I turn off "hyperlink could be harmful" warning in Access

[Guest]

I am using hyperlinks to word docs on my harddrive how do I turn off the
"Hyperlink can be harmfull" warning. (Using xp home and Access 2003)

 

[TC]

This might or might not help. Try starting your database from a file
named DOIT.VBS containing the following statements:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1
o.opencurrentdatabase "full path to your database"
o.visible=true
o.usercontrol=true
set o=nothing

I don't quite remember the order of the viasible & usercontrol
statements. If you get an error on the second of those two statement,
reverse their order & try again.

You can name the file whatever you like, as long as you give it the VBS
extension. Be sure to create it using a simple text editor like
Notepad. Do not use a word processing program like MS Word, unless you
are careful to save the file in plain text format.

As I say, this might or might not help. Post back & tell us.

HTH,
TC

 

[Guest]

Hi TC
Could you please explain this code and why you it will stop the hyperlink
warning.
Thanks

 

[TC]

Access 2002? 2003? exposes a new property called AutomationSecurity.
That property lets you set the macro security level, for one specific
run of a database, without affecting any other databases. This is much
better than lowering the macro security level of the whole PC.

My code sets that level to Low (value 1), for one specific run of your
database. I'm guessing that this could stop the hyperlink warnings. But
I can't be sure because:
(1) You haven't said what version of Access you are using, and
(2) I just don't know whether hyperlink warnings are affected by the
macro security level; but it would make sense if they were.

So give it a try, & see if it helps!

If you're worried that this is bad code which will harm your database,
just google this group for posts from me (TC) and/or containing the
word automationsecurity. You'll see that I have suggested this to many
people with similar problems.

HTH,
TC

 

[Guest]

thanks i will try it but setting the macro securty to min has no effect so
don't know wether it will work I'll let you Know.

 

[Paul Overway]

It won't have any effect. Use Docmd.FollowHyperlink in code instead of
clicking on the link directly.

 

[Rob]

Paul,

Where would you put this code? In the On Click event of the textbox? I
have also tried to modify the registry entry and add the
DisableHyperlinkWarnings in the Common section of Office11 - did not work.

Thanks,

Rob

 

[simon oakley]

I've struggled with this, too. I tried adding DoCmd.SetWarnings False' as an
event when the command button is clicked, but to no avail...would be really
grateful for a solution. Simon, UK

 

[Jeanette Cunningham]

There is not any simple way to do this. However I have found this website
very helpful for this problem.

http://www.allenbrowne.com//func-GoHyperlink.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia