How to Suppress Warning Pop-up Warning

Topic

New Reply

In URL fields, I have plenty of links like c:Program Filesabc.exe. When clicking it, it always pop up a Microsoft Office dialog window warning of trustworthy source. How to suppress this annoying popup?
Thanks.
Armstrong

Reply | Quote

Replies

Try How to disable hyperlink warning messages in Office 2003 or How to disable hyperlink warning messages in 2007 Office programs.

Reply | Quote

Hi Leif,
Thanks for your help.
Your solution is only applicable to non .EXE files.
What if .exe executable files?
Armstrong

Reply | Quote

Your solution is only applicable to non .EXE files.

The first part of each the pages linked to contained this

Did you try the suggestion for executable files?

Reply | Quote

Hi John,
I must miss something. What do you mean by “Did you try the suggestion for executable files?
Armstrong

Reply | Quote

Hi John,
I did insert DisableHyperlinkWarning in HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0Common[/b].
Do I have to insert DisableHyperlinkWarning in HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0Common[/b] as well?
I only have Office 2007 on my Win7 X64 Ultimate.
Armstrong

Reply | Quote

Actually the more appropriate URL is http://support.microsoft.com/kb/925757.

At least in either case, the DisableHyperlinkWarning subkey won’t work. That’s what I meant.

When reading further, the alternative solution includes:
Method 1: Turn off the “Confirm open after download” option for the file type that you are trying to open
In Win 7 X64, simply there’s no such things as “Folder Options” and “Confirm open after download”.

Armstrong

Reply | Quote

What tormenting me most is most other file extensions such as PDF work successfully.

Reply | Quote

Of course, it’s possible to include an executable as a URL such as c:MyPgmabc.exe.
When clicking such URLs, Access will pop up a warning dialog box?
How to block these annoying warning dialog boxes?
Armstrong

Reply | Quote

I don’t know the answer to your question!

I re-read (more closely) the Microsoft posts linked to early in this thread, and realised I had misunderstood them before.
They do not offer a solution for exe files. And maybe the last line of what I have posted below is telling us there is no solution.

The only workaround I can think of is to replace all the hyerlink fields with plain text fields, then use VBA code to open the files.

Code like this will run an exe without a warning message.

Code:

If Right(Me.link, 3) = "exe" Then
 	Shell Me.link, vbNormalFocus
 Else
 Application.FollowHyperlink Me.link
	End If

It seems to me that this is not an Access question. It is either an Office question, or more generally a Windows 7 question. Moving the thread to the Win 7 forum will expose it to some new eyes who may have something extra to add. Would you like me to do that?

Reply | Quote

John,
At least you help me learn a new piece of code. Thanks a lot.
Armstrong

Reply | Quote