A2000: make mult. PDFs from one report

[A Man]

I have Access 2000 and Acrobat Pro v8.

I have a giant report with 800+ customers. For each customer I list the
products they ordered. Each customer "sub section" of the report could
be 1 or more pages, I just don't know.

I need to make a separate PDF for each customer from this one report. Is
there a way to do this with code, or a simpler way?

Thanks.

 

[Ron Weiner]

I see this as a 4 step process.

Step 1 Create a report that displays data for one customer

Step 2 Learn how to programmatically create a PDF from your report. Hint:
Go here http://www.lebans.com/reporttopdf.htm Download the sample
database. Port Stephens code in your DB.

Step 3 Learn how to send an Email with an Attachment. There are MANY
methods and tons of sample code on the Web.
http://www.google.com/search?hl=en&q=Access+Send+Email+with+attachment

Step 4 Repeat running the report in Step 1, creating the PDF in Step 2 and
Emailing the result in Step 3 800 times (once for each customer)

If you get stuck on a particular step, ask a specific question here.
Provide enough information about what you are doing and what errors /
problems you are seeing with your code. I am sure you will get sage advice,
and you will be learning something new that you can add to your own
programmers bag of tricks for future projects.

Ron W

 

[A Man]

Thank you. This points me in the right direction.

 

[A Man]

I am pretty rusty programming in Access, and when I did program, I only
used DAO recordsets. Can someone tell me how to loop through my customer
table and produce a report PDF for each customer?

Or would I only have to loop through a customer table and set the WHERE
clause of the report? Or the filter property. I don't know how to do
either but I know the properties are there.

(See above question same thread.)

Thanks.

 

[Ron Weiner]

Google is your friend!

http://www.google.com/search?hl=en&q=Access+DAO+Recordset&btnG=Google+Search

Got me > 200, 000 Hits

The third one looks promising

http://www.granite.ab.ca/access/email/recordsetloop.htm

Ron W