I have an table with attachment field in which PDF files are attached.
I need Access 2013 form to display PDF file content instead of PDF icon
While record changed should display PDF content for each record navigated
I have an table with attachment field in which PDF files are attached.
I need Access 2013 form to display PDF file content instead of PDF icon
While record changed should display PDF content for each record navigated
Use a "WebBrowser" control.
how can I assign data from attached field to web browser control
You can either set it in the Data tab of the WebBrowser object properties and clicking on the ellipsis next to "Control Source", or you can set it programmatically through VBA code.
Code:Private Sub Form_Load() Me.WebBrowserName.ControlSource = "c:\root\subfolder\filename.pdf" Me.Refresh End Sub
I wont be pulling pdf files from drive. I have already attached files in a table field. when I run my form my jpg file shows the pictures where as pdf file contents not displayed it show PDF icon
Are you aware Access has a 2GB size limit? Files embedded in attachment field can use up that limit fast.
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.
Access doesn't natively support the displaying of PDF files that's why it must be displayed in the web browser. You can export the Attached file as a PDF file then display it in the web browser but that would require some bit of coding and much more information about your database.
Thanks to all, I did the same...saved attachments to a folder and pulled from there....