Unanswered: How to display PDFs in an Access form?
I am using Access 2007. Access 2007 has the Attachment field type, but you can't display PDFs, just a handful of image files, so that won't work for me.
I want to display PDFs in a subform for the users. A given record can have zero, one or multiple associated PDFs. I don't want to store them inside the database because it'll bloat with thousands of PDFs. I think I'm supposed to use some type of OLE Object. Bound or Unbound? How do I get the PDFs to display? I've already got a text field to store the full path, but I don't know what to do next. Help! I've been searching for answers all morning to no avail.
You need to find an ActiveX control that can be included in an Access Form and that is able to display a document in pdf format. I looked around and it does not seem to be easy to find one, at least for free.
Now, my next problem is getting this to work on the report. The report contains all the data fields for a particular record, and then displays the PDF(s), one per page. I've created a subreport for the PDFs, but none of the events seem to happen, so I don't know how to get the code to activate, either this code or Canupus' idea.
So I got the form working fine. I'm using an Unbound Object Frame using the code I posted on 10/18. It works OK, except the quality of the PDF is very degraded, to the point where it's unreadable. I've tried switching between clip, zoom and stretch, but it doesn't help. Is there a setting to keep the PDF file quality intact when displaying and printing the form?