Send report to separate files (Print to File in Adode)

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

I need to send a multi page report to separate files in
Adobe pdf format.
The files need to be named the same with the addition of
data which is located in 1 field of the underlying query.
The data in the underlying query field will also be what
determines the new file. For instance, each file will be
called: Porches, and will have the style number from the
underlying query field added to the name. And the style
number will determine where the new files start and
end.
Any help you can offer would be most appreciated.
Thanks.
 
Liz:

If you have any number of pdf printer drivers on your system, our PDF and
Mail Library for Access should allow you to easily automate that process.
You simply have to loop through a recordset that represents the underlying
recordset for the report, and for each unique customer, group, whatever,
specify the filter to use and file name for output and away you go. You'll
find it on our web, the help file has examples of this type of process.
 
Back
Top