Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Canít Get Rid of Security Message? (IE7)

    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. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

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

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Canít Get Rid of Security Message? (IE7)

    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

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Canít Get Rid of Security Message? (IE7)

    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).

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Canít Get Rid of Security Message? (IE7)

    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>post 466986</post#> 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

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Canít Get Rid of Security Message? (IE7)

    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:
    <code>
    lngResult = ShellExecute(hWndAccessApp, "Open", "C:WindowsSystem32MSPaint.exe", Chr(34) & "C:TestLogo.bmp" & Chr(34), 0&, SW_SHOWMAXIMIZED)
    </code>
    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?

  7. #7
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Canít Get Rid of Security Message? (IE7)

    Great solution, thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •