PDF files as OLE Unbound Object in Report

[Pete M]

I have several .pdf files that i want to print in a report. Each are
associated with a record, i want the one displayed on the report to vary
depending on each record.

I cannot embed the files in a table as OLE objects and display them in a
bound object control because the size of my project becomes way too large
(>600MB).

I have tried this using code, but the control never updates--i.e. the pdf
stays the same for each record in the report. Here is what i've tried:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Set ole1 = Me.OLEUnbound191
ole1.SourceDoc = CurrentProject.Path & "\Flowcharts\" & Me.[Process
Flowchart] 'Me.[Process Flowchart] is the name of the .pdf file
ole1.Requery

End Sub

What do i need to do?

Thanks in advance!

Pete M

 

[BigJohn]

the imbedded OLE control is just that, imbedded and requires the data to be
in the record.

If you do get this figured out, you will very quickly run into the second
problem with this control - it only shows the first PDF page. If you have
multiple pages in one file, pages 2 - n will not be displayed and there is
nothing to do which will get it.

If you are tempted to use Crystal Reports (8 - 10 I have tried), they have
the same problem.

If you are using Access 2003, I believe the maximum file size is 2GB which
will futher limit the longevity of your application.

If you want to upsize, SQL Server 2005 can handle the space references using
an Image file type and it will store a pointer to a disk file. MS Access
will consider this field on a linked connection as a Memo field, but will
continue to display page 1 only.

When I asked the paging question to this board, I was told to set my
provider to display multiple pages, but never received an answer how to
correct the PDF problem.

I eventually moved to VB.Net 2005 with Crystal and PDF995 to "glue" the
files together.

Good Luck.