Either using the product I mentioned or writing it yourself would both work.
When you say based on a field, I'm assumming you are just saying
- I have a lot of records in Access
- these records have one particular field that when the value in this field
is the same value I want all those records on the report
- I then want all of these possible reports to be made into pdf files
Loop thru recordset which best allows you to build the individual where
clauses for each report.
It's tough to give you specifics without knowing more details on the
project.
HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com
"PierreRobert via AccessMonster.com" u59968@uwe wrote in message
news:a7d8a651336e1@uwe...
Thank you. I realized I wasn't precise with my wording: I should have said
"based on a field", not "based on a criterium."
i've also come to the terrible realization that the code I was thinking of
was actually used in Excel to split a worksheet into seperate workbooks
based
on cells in different groups. I imagine creating and saving separate PDFs
based on field will be a lot more challenging. Which of the suggestions
below
do you think I will have the most luck using for my purposes?
Mark Andrews wrote:
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
Folks, I'm losing my mind: I know I have used before some relatively
simple
[quoted text clipped - 11 lines]
before. Any idea how I can accomplish this with not *too* much vba?
The
solution I used before was pretty straightforward and elegant.
--
Message posted via http://www.accessmonster.com