Access Default Hyperlinks Warning

[iglobalusa]

I have a command button when clicked links the user to a trusted website. However, Access shows a default message: "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?"

Is there a way to disable this default message using VBA code?

 

[boblarson]

Perhaps this will help:
http://support.microsoft.com/kb/829072

 

[iglobalusa]

Thanks for your assistance!

 

[iglobalusa]

Is there a way of doing this in VBA code?

 

[nIGHTmAYOR]

Microsoft access registry editor module is restricted to "Vb & Vba applications" section of registry , however when i am stuck with it i always head for scripting object designed mainly for vba scripts of asp3 , so here goes :

Dim objShell As Object
Set objShell = CreateObject("Wscript.Shell")
objShell.RegWrite "HKCU\Software\Microsoft\Office\11.0\DisableHyperlinkWarning", 1, "REG_DWORD"

 

[nIGHTmAYOR]

DisableHyperl inkWarning <-- for a peculier reason the forum inserts a space within the word hyperlink so you should strike it out manually

 

[Rabbie]

DisableHyperl inkWarning <-- for a peculier reason the forum inserts a space within the word hyperlink so you should strike it out manually

If you use the code tags when posting you will avoid this spurious space problem. Also it makes the code easier to read

 

[nIGHTmAYOR]

Thanks for the tip , now i have to go advanced on every post

 

[boblarson]

Thanks for the tip , now i have to go advanced on every post

No you don't - just type the code tags in. It isn't hard. [] with the word code in the square brackets and at the end [/] with the word code after the /