Printing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amateur - 08 Mar 2005 13:27 GMT

I sorted my report by Customer number. There are +/- 60 customers listed in
that report.
NOW, I would like to print each customer report to a differnt folder (if
possible in PDF Format) by pushing one button. How, and where do I have to
program that?
Can anyone help?
I tried with http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm but it only makes it easier to print the total report in a
PDF format -but it does not give me the solution for splitting my report into
the different customer ID's folders

Thanks in advance
Klaus

Reply to this Message

phillip9 - 08 Mar 2005 15:05 GMT

Hello,

I belive, to do what you want, would require you to program a Loop in VBA.
i might handle the task similar to this.

1. create a form
2. put a button on the form.
3. program VBA code to loop through my query results, that make up the
full-report
4. use the code from ACG Soft to print each individual sub-report as a PDF

If there is an easier way to do this, I would love to hear about it.

Thanks for the information on ACG Soft, they have some interesting looking
products.

Phil

> I sorted my report by Customer number. There are +/- 60 customers listed in
> that report.
[quoted text clipped - 9 lines]
> Thanks in advance
> Klaus

Reply to this Message

Duane Hookom - 08 Mar 2005 19:36 GMT

Seems as though you posted this same question in another thread. This is
generally frowned on.

Also, you have asked several questions in these groups and should learn to
use a more descriptive "Subject:". Maybe something like: "Printing one PDF
for each customer" or something similar.

Signature

Duane Hookom
MS Access MVP

>I sorted my report by Customer number. There are +/- 60 customers listed in
> that report.
[quoted text clipped - 10 lines]
> Thanks in advance
> Klaus

Reply to this Message