Print report using data field names

[max2great4u]

I have a report which contains more than 100 pages, I need to know is
there a way to print each individual page with a different name or i
need to use a field name and save the printed file(PDF format) with the
respective field name.

 

[Larry Linson]

I have a report which contains more
than 100 pages, I need to know is
there a way to print each individual
page with a different name or i
need to use a field name and save the
printed file(PDF format) with the
respective field name.

Access does not support printing the pages of a report separately. I'm not
at all sure what you mean by "use a field name and save the PDF"?

If you know what data you want on each "page," yes, it may be possible to
code to print 100 separate reports. Or, it may be possible to manipulate the
page numbers so each of the 100 pages is Page 1 or Page 1 of 1, so the 100
pages appear to be separate reports. But 100 separate reports, I suspect, is
the only way to generate 100 separate PDF files.

Larry Linson
Microsoft Access MVP

 

[max2great4u]

Hi,

I totally agree with what you say, what i need is if a report has 100
invoices i need each invoice to be printed as a PDF file and it should
be saved automatically with the respective invoice number, I know it's
possible it's just that i'm not able to crack.

Any help in this regard will be greatly appreciated

 

[Larry Linson]

I totally agree with what you say,
what i need is if a report has 100
invoices i need each invoice to be
printed as a PDF file and it should
be saved automatically with the
respective invoice number, I know it's
possible it's just that i'm not able to crack.

If it is possible to print "pieces" of the _same report_ as separate PDF
files, it would have to be done in the PDF, or by post-processing the PDF.

If you create a Report that prints one invoice, and can clarify how you want
to select the invoices to be printed, perhaps someone could offer useful
suggestions on how to print the multiple one-invoice reports as PDFs which
will accomplish your purpose.

My own use of PDF has been to have Adobe Acrobat installed as a printer and
manually select it when printing from Report Preview mode.

Larry Linson
Microsoft Access MVP

 

[Pieter Wijnen]

Win2PDF is one comercial product to autocreate PDF's
There are several others
see http://www.groupacg.com/

Pieter

If it is possible to print "pieces" of the _same report_ as separate PDF
files, it would have to be done in the PDF, or by post-processing the PDF.

If you create a Report that prints one invoice, and can clarify how you
want to select the invoices to be printed, perhaps someone could offer
useful suggestions on how to print the multiple one-invoice reports as
PDFs which will accomplish your purpose.

My own use of PDF has been to have Adobe Acrobat installed as a printer
and manually select it when printing from Report Preview mode.

Larry Linson
Microsoft Access MVP

--

 

[max2great4u]

I have Adobe Acrobat 6.0 Professional and it is selected has default
printer, now i want to send each invoice number in loop and print that
particualr invoice as one PDF file.
any code in this regard will be of great usefull.