seperate .pdf files from 1 report

  • Thread starter Thread starter dkingston
  • Start date Start date
D

dkingston

i am using access2002 and adobe acrobat distiller to print
customer statements.
currently, when i print the report i get a single .pdf
file that contains all of the statements.
is there a way to have access generate a seperate .pdf
file for each account and use the account number for the
name of the file?
many thanks in advance for your help.
please reply via post or to:
d k i n g s t o n (at) j a g l y n n (dot) c o m
 
d:

There's no automated way to do this in Access, other than to loop through a
recordset that underlies the report and for each distinct account number
output the report (i.e. print it) to distiller), setting the account number
as the SQL where clause in your docmd.openreport call.

If you want a way to automate this a bit, including setting unique file
names, then take a look at our PDF and Mail Library for Access. You'll find
it on our web with lots of code examples on how to do exactly what you are
trying to do.
 
Back
Top