I have (finally) developed a MSAccess2000 report that is based on a
select query, where the user must enter an id number for the employee
whose information they want to see; then they "print" the report to a
.pdf file, using Adobe Distiller set up as a "printer".  How do I
automate that process to save a copy of the report for each employee in
.pdf format, so the user does not have to go one by one?
For example, the user might want .pdfs for each Arizona employee.

Thanks.

you could modify the report to group by employee, with a page break in the
group footer.  Then, modify the query to remove the prompt for id number and
instead retrieve the entire table of employees.  This will create one PDF
with each report on a separate page.

if you need separate files for each employee, then you could write a macro
or even a VBA module that will step through each record and supply the its
id to the query/report.



-----Original Message-----
From: Silas Wild [mailto:SILAS@d...]
Sent: Monday, August 26, 2002 5:58 PM
To: Access
Subject: [access] Run a report multiple times (newbie question)


I have (finally) developed a MSAccess2000 report that is based on a
select query, where the user must enter an id number for the employee
whose information they want to see; then they "print" the report to a
.pdf file, using Adobe Distiller set up as a "printer".  How do I
automate that process to save a copy of the report for each employee in
.pdf format, so the user does not have to go one by one?
For example, the user might want .pdfs for each Arizona employee.

Thanks.