printing to pdf

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

i have an access database that produces our company billing run from a
single report containing multiple sub reports.

The report is then printed to pdf format as it is quicker to scroll through
than waiting for access to format the pages (in excess of 1400 pages)

There are appoximately 250 customers and i was wondering if it is possible
to create a pdf for each individual customer using the one report.

Please accept my thanks in anticipation

rgds

Colin
 
You could automate the printing of the report, but putting the OpenReport
command in a loop for instance:

For Each Customer in CustomerList
Call DoCmd.OpenReport(RPTNAME, acViewNormal, , _
"[CustomerID]=" & Customer.ID )
Next
 
Back
Top