View Single Post
  #2  
Old May 11th, 2010, 12:47 PM posted to microsoft.public.access.reports
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default Automate saving multiple pdfs from single report based on criteria

You could have been referring to our batch reporting module which we used to
sell. We just rolled that code into
our email module so it does both batch reporting and email templates.

http://www.rptsoftware.com/products/email/

See the section on batch reporting.

Alternatively you could write some code to loop through a recordset and call
the report with a where clause or
alternatively build query(s) on the fly before running each report (for more
complex senerios).
In Access 2007 you could use the built-in way to make pdf files. In Access
2003 and earlier you could use
Lebans pdf code or write code to set registry keys and print to a pdf
printer driver in the appropriate manner.


HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"PierreRobert" u59968@uwe wrote in message news:a7d36116376d7@uwe...
Folks, I'm losing my mind: I know I have used before some relatively
simple
module that, with just a little tweaking, allowed me to click a button,
launch a report, and name and save it into multiple, individual pdfs based
on
a criterium. I'm pretty sure it was not Leban's work, and it might have
been
referenced on an MS site.

I know this sounds like something I should be able to find, but I've now
searched for over two hours and can't for the life of me find it. There
seems to be a lot of complex solutions that are beyond me and not what I
used
before. Any idea how I can accomplish this with not *too* much vba? The
solution I used before was pretty straightforward and elegant.