Print .pdf files as part of a report

  • Thread starter Thread starter HSalim
  • Start date Start date
H

HSalim

To create pdf docs from your report, you can use a PDF creator like
Distiller from adobe
or one of the many 3rd party tools. They behave lika a printer driver, so
you would print to your PDF printer.
I use CutePDF from www.acrosoft.com which is free - totally free, no nag
messages either, and it works perfectly.
It even creates the bar codes perfectly.

to create a DOC use you could try docmd.transfertext

HS
 
Sounds like you mean to add an existing PDF or DOC into your generated
report. I don't have an answer for you but it sounds like the other
responses misunderstood your question - a common problem in newsgroups. Then
again maybe I misunderstood.
 
I wish to be able to print *.pdf and *.doc data files as part of a
report. Any suggestions as to how to do this would be most welcome.
Click to expand...

You will need to print the desired documents using code. You will need to
determine, in your code, which file(s) you want to print, then use an api to
print the file using the proper command line or use an api to retrieve the name
and location of the associated application (EXE), then use that returned value
in your "Shell()" call to print the file. Two methods that I can think of are:

I'm not sure if the following API will work while passing command-line switches
(such as a "print" switch), but this api is designed to open the associated .EXE
automatically when you specify a document to open that has an association in the
registry):

API: Start an app with ShellExecute
http://www.mvps.org/access/api/api0018.htm

In the event the preceding doesn't work, you can always retrieve the name of the
associated .EXE using this api call:

API: Find the associated EXE file
http://www.mvps.org/access/api/api0023.htm

Of course, you will need to know the command-line needed to tell the application
to simply "print" the file rather than just open it.
 
Frequently, the command line for printing can be found by opening an Explorer window and
going to Folder Options, File Types tab and see what information is available for the file
type. Be careful to just look, don't change anything here unless you're sure about what
you're doing.
 
Frequently, the command line for printing can be found by opening an Explorer
window and
going to Folder Options, File Types tab and see what information is available for the file
type. Be careful to just look, don't change anything here unless you're sure about what
you're doing.
Click to expand...

Thanks, Wayne. :-)
 
Myron:

Others have posted a response, but I'm not sure that they've gotten to your
question. If you mean by printing pdf and doc files as incorporated parts
of a report (i.e. embedded in the report itself). Then there are some
severe limitations to being able to do this from within Access.

1.) There is no control available or any other way to place a PDF file on an
Access report at this point in time. Adobe's PDF container control does not
support the ActiveX interface of Access reports (although it works with
forms) and so a PDF will not display as an incorporated part of an Access
report. There is simply no way to do it.

2.) From the stand point of Word documents, you can embed these into an
Access report, usually as a linked OLE document. The draw back is that as
with all OLE containers on Access reports, you are limited to one page of
display/print of the Word document, it can not go to page two, nor can the
OLE container be resized at run time if you have varying size / length of
text of the document.

OK, so there's the bad news.

On the other hand there is a method to combine and print your Access report,
Word docs and pdf files into one document and output it to print or file.
The PDF Pro edition of our PDF and Mail library for Access will allow you
to, from within Access, output your Access report to a PDF file via code,
output your external Word doc to PDF file and then merge the whole thing
into one document with any external PDF file you need to incorporate and
print it and or simply store it on on a drive. You'll find it on our web if
that's of interest to you and it addresses your need.
 
what does the "cute" in "cutepdf" mean?


SA said:
Myron:

Others have posted a response, but I'm not sure that they've gotten to your
question. If you mean by printing pdf and doc files as incorporated parts
of a report (i.e. embedded in the report itself). Then there are some
severe limitations to being able to do this from within Access.

1.) There is no control available or any other way to place a PDF file on an
Access report at this point in time. Adobe's PDF container control does not
support the ActiveX interface of Access reports (although it works with
forms) and so a PDF will not display as an incorporated part of an Access
report. There is simply no way to do it.

2.) From the stand point of Word documents, you can embed these into an
Access report, usually as a linked OLE document. The draw back is that as
with all OLE containers on Access reports, you are limited to one page of
display/print of the Word document, it can not go to page two, nor can the
OLE container be resized at run time if you have varying size / length of
text of the document.

OK, so there's the bad news.

On the other hand there is a method to combine and print your Access report,
Word docs and pdf files into one document and output it to print or file.
The PDF Pro edition of our PDF and Mail library for Access will allow you
to, from within Access, output your Access report to a PDF file via code,
output your external Word doc to PDF file and then merge the whole thing
into one document with any external PDF file you need to incorporate and
print it and or simply store it on on a drive. You'll find it on our web if
that's of interest to you and it addresses your need.
Click to expand...
 
Greetings

I wish to be able to print *.pdf and *.doc data files as part of a
report. Any suggestions as to how to do this would be most welcome.

TIA
Myrlin
 
Back
Top