Printing OLE PDFs

[Perplexed by pdfs]

I can't seem to print PDF files in a report if PDF is more than 1 "page" I
just get a big fat icon. Single page files seem OK. Also, a linked OLE
(either office or pdf) you only get an icon in the report, not an image if
the file was imbedded. Or do I have to format the report so it's large
enough to cover all the pages?

 

[Albert D. Kallal]

I can't seem to print PDF files in a report if PDF is more than 1 "page" I
just get a big fat icon. Single page files seem OK. Also, a linked OLE
(either office or PDF) you only get an icon in the report, not an image if
the file was imbedded. Or do I have to format the report so it's large
enough to cover all the pages?

I can never understand why people using MS access with one of the world's
best report writers come along and try and stick inside of a report a PDF
document? This approach is just so unworkable. Furthermore you'll have
all kinds of problems like your application breaking when you run one
of the frequent updates that adobe seems to send out for their PDF viewer.

Furthermore, as you found out how to specify which pages of the PDF document
is not really possible, and you have really no control over that PDF
document shoved inside of an MS access report. I just have to say plain and
simple MS access is not designed to work this way. Nor is the PDF viewer
from Adobe either.

I would suggest you do one of two things:

1) format your information to use MS access reports. You can then
print that report on demand. And, if you need a PDF, then send the
report to a PDF document (Stephens who frequently post's here has some free
code that allows you to create a PDF document without having to install any
Adobe product).

2) Write some code to store/save a direct path name to a PDF document on
your
hard drive, and then have the ms access code print that docucument.

In MS access you can print a PDF document from code regardless of what
version of Adobe installed with folwling one line of code

CreateObject("Shell.Application").Namespace(0).ParseName("c:\mypdf\myDoc.PDF").InvokeVerb
("&Print")

It's not at all clear why you're trying to embed a PDF document inside of a
report, but I suggest that you modify your design and use MS access to print
a PDF document from the hard drive.

Don't try and throw a pdf inside of an MS access report...it will be nothing
but a painful experience.

 

[Perplexed by pdfs]

Thank you for your input. I understand what you are saying but perhaps I
will expand on my issue:

I am running the report from a query (not actually embedding a pDF into the
report) with the query retreiving data from a bunch of tables (one of which
contains the PDF documents...)

You can view and print the PDF's (single page PDF's only) in the report by
selecting DISPLAY|Content in the properties for the control in the report.
I'm trying to see if multiple pages can be supported but I'm resigned this is
probably not possible. \

I cannot seem to veiw the content of a LINKED OLE, regardless if it's JPEG,
PDF, DOC, XLS etc... only BMP's seem to view as content if they are linked.
If a could solve this issue would go a long way as I want to avoid embedded
files in the database by linking to them instead... but they won't view
contact if linked, just an icon. Any further suggestion would be appreciated
and hope this is more clear what I"m trying to do. (Can't convert to MS
friendly as is not the standard we are working with and also, same problem
arises)

Thanks,