Multiple page report to separate files

  • 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 the where the new file starts and
ends.
Any help you can offer would be most appreciated.
Thanks.
 
Liz:

Stop by our web and look at our PDF and Mail Library for Access. It would
allow you to output the PDF files automatically to a specific file name and
by looping through your report's underlying recordset, filter the report as
its output and set the file name to include any field you have in that query
or view. You'll find it in the developer tools section of our web.
 
Steve,
This would be perferct if I was using it at home...however
it is for work and unfortunately I cannot authorize, or
download items from the internet.
Is there any type of VB coding that I can use instead?
Thanks.
 
Back
Top