Results 1 to 6 of 6
  1. #1
    JMC is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2014
    Posts
    3

    Using Web


    I'm using Access 2013, Adobe Acrobat XI, and Google Chrome on Win8.

    I have a database that tracks expenditures and have each receipt scanned to a pdf file. I would like to display the corresponding/unique receipt (pdf) for each expenditure/record.

    I added a field called ScanFileName to both the table and form and wrote a function to populate the field with the path and file name for the corresponding receipt. It populates with something that looks like this: "File:///c:\MyAppPath\Scans\REC 0001.pdf"


    I added a Web Browser Control to the form and set the control data source to the ScanFileName field.

    The control is displaying the "The program cannot display the web page" browser page.

    I'm not sure what I am doing wrong - any help would be greatly appreciated
    Attached Thumbnails Attached Thumbnails Capture WebPage Error.JPG  
    Last edited by JMC; 01-22-2014 at 01:12 AM. Reason: add attachment

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,628
    Does this help http://stackoverflow.com/questions/1...tent-on-a-form

    I tested setting the ControlSource property of Browser Control and it worked with:

    ="C:\Users\June\Forums\Save\RecordsLeftToRight.pdf "

    Why do you have the File:/// prefix?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    JMC is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2014
    Posts
    3
    I put the "File:///" because someone over in the Microsoft form told me that was the syntax.

    I just pasted ="C:\Users\MyName\Documents\Scans\REC 0012.pdf" into the Web Browser Control Source Property and get a different error now. The Web Browser Control has the following error: "To help protect your security, your web browser restricted this file from showing active content that could access your co...". And then when I tell it to allow blocked content, the Web Browser Control is empty. When I googled this error, the only relevant reference I could find instructed me to change an IE internet option setting to "Allow active content to run in files on My Computer". I changed this setting (even though I am using Chrome) and rebooted, but the error still displays.



    Click image for larger version. 

Name:	Capture Web Browser Control Error.JPG 
Views:	15 
Size:	23.5 KB 
ID:	15155

    Click image for larger version. 

Name:	Capture Web Browser Control Error 2.JPG 
Views:	15 
Size:	23.8 KB 
ID:	15154

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,628
    Maybe you need to also change some setting in Chrome. I tested the Browser control on my home laptop and office PC. Neither generated that warning. I cannot replicate the issue.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    JMC is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2014
    Posts
    3
    Thank you so much for taking the time to test this - it narrows down the potential causes. The thought that it might be a chrome setting crossed my mind as well. I looked in Chrome settings, but didn't see anything similar to the setting I changed in IE. I think I need to figure out if the web browser control is using IE or Chrome. So I don't 'google' down the wrong path - I want to confirm that the control is ActiveX? It's a shot in the dark, but maybe changing my default browser from Chrome to IE might make a difference.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,628
    I guess it is an ActiveX http://support.microsoft.com/kb/815725
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums