Create few reports out of one & print out to PDF

  • Thread starter Thread starter Eva
  • Start date Start date
E

Eva

Hi
I have a querry where I have number of customers
Then I have a report with data for all of them
I would like to print out separate PDF files for all customers.
How to do it?
 
Eva said:
I have a querry where I have number of customers
Then I have a report with data for all of them
I would like to print out separate PDF files for all customers.
Click to expand...

You need to loop through each record in the query and then produce the
individual reports.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required. Free.
http://www.lebans.com/reporttopdf.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top