Prev: To Query or not to Query??
Next: Do reports suck? How to set conditional page breaks between subrep
From: Mark Andrews on 13 May 2010 16:26
Yes control the code so the report you run produces the pdf you want. In
this case a couple hundred pdf files.
Don't make one big pdf and then try and break that into many pdfs.

Access2003 and earlier most people use stephen lebans code to make the pdf
file
Access2007 pdf output is built-in
You can control some pdf print drivers via registry keys that can be coded
(a bit more work)

HTH,
Mark

"PierreRobert via AccessMonster.com" <u59968(a)uwe> wrote in message
news:a7e528d1bbad3(a)uwe...
> Yes. I have thousands of records, and a field with a couple hundred
> unique
> values--in this case, schools. I have reports that group the records
> based
> on school. I run the report, create a pdf, then break the pdf into the
> couple hundred of unique reports based on school. I do this for four
> reports.
> That's a lot of time wasted making sure I break in the right place and
> changing the file name.
> I will look into looping through the recordset, which is similar to what I
> did in excel, I believe, but I am still worried about integration with
> Adobe/making PDFs.
> Thanks again.
>
> Mark Andrews wrote:
>>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
>>
>>> Thank you. I realized I wasn't precise with my wording: I should have
>>> said
>>> "based on a field", not "based on a criterium."
>>[quoted text clipped - 39 lines]
>>>>> The
>>>>> solution I used before was pretty straightforward and elegant.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1
>
First  |  Prev  | 
Pages: 1 2
Prev: To Query or not to Query??
Next: Do reports suck? How to set conditional page breaks between subrep