Can’t Get Rid of Security Message? (IE7)

Topic

New Reply

I have a Access form with the following command in After_Update:

strAppName = “C:WINDOWSexplorer.exe” & ” ” & strFilePath & strFileName
Call Shell(strAppName, 1)

Note: strFilePath & strFileName contains”
F:PropertiesStreetsAbbott RdAbbott Rd 1219APREWK_T.TIF

The code works OK, however I get the following security messages before the file is opened:

To help protect your security, Internet Explorer has restricted this file from showu=ing active content yhay could access your computer. Cleck here for options…

I Turn Off Pop-up Blocker without success.

I followed Information Bar Help without success.

Automatic prompting for ActiveX controls, click Enable.
Automatic prompting for file downloads, click Enable.

I’m missing something, how do I turn off the above message?

Thanks, John

Reply | Quote

Replies

See Improvements in Windows XP SP2: How Internet Explorer is safer under the hood in XP SP2 for the reasoning behind this warning. The article explains how to suppress the message and why you shouldn’t do that.

Do you have a specific reason for wanting to display a .tif file (fax?) in Internet Explorer? Most graphics viewers can display .tif files.

Reply | Quote

There is probably a better way. This is what I’m trying to do.

I have a directory structure as follows:

f:PropertiesStreetsAbbott Rd RearAbbott Rd Rear 1245
f:PropertiesStreetsAbbott Rd RearAbbott Rd Rear 2019
f:PropertiesStreetsAbbott RdAbbott Rd 1201
f:PropertiesStreetsAbbott RdAbbott Rd 1219

In each street address directory there are one or many tif files that contain paper items that have been scanned into each street address directory.

The Access application reads the path and tif file names into a table

I have a form with cascading combo box that user will select a street from the above table:

Abbott Rd Rear 1245
Abbott Rd Rear 2019
Abbott Rd 1201
Abbott Rd 1219

Then a second combo box that the user will select the image file to view:

Abbott Rd Rear 1245 f:PropertiesStreetsAbbott Rd RearAbbott Rd Rear 1245Plans.tif
Abbott Rd Rear 1245 f:PropertiesStreetsAbbott Rd RearAbbott Rd Rear 1245Voilations.tif

Currently using Explorer the image is opened with Windows Picture and Fax Viewer

Is there a better way to view these images in the directory structure that I have.

Thanks, John

Reply | Quote

You can use ShellExecute with the Open option to open a .tif file in the associated application. Do a search in the Access forum for shellexecute, you’ll find several examples, e.g. Re: dblclk .pdf? (2000).

Reply | Quote

Hark!, You gave that answer here:

Re: Best Way to Open Hyperlink Fields? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
post 466986 re: 466,908 from Support4John

This eliminates the Explorer security message and opens my image with Windows Picture and Fax Viewer
And allows me to cycle through all images in the street directory which is very nice.

Using ShellExecute do I have any control over which graphics viewer I can use to open the image?

Thanks, John

Reply | Quote

If you want to control which viewer is used, you can use the lpFile argument of ShellExecute to specify the app and the lpParameters argument of to specify the file to be opened, for example:

lngResult = ShellExecute(hWndAccessApp, "Open", "C:WindowsSystem32MSPaint.exe", Chr(34) & "C:TestLogo.bmp" & Chr(34), 0&, SW_SHOWMAXIMIZED)

Notes:

1. The file path+name is enclosed in quotes Chr(34) – this is essential for if the path or filename contains spaces.
2. If you only specify a file name in lpFile, ShellExecute simply opens the file in the application that is associated with the file type (extension) on the end user’s PC. So a .tif file may open in Windows Pictures and Fax Viewer for you, and in FastStone MaxView for me. I see that as an advantage (in general) – different users have different preferences, and who am I to argue with that?

Reply | Quote

Great solution, thank you

Reply | Quote