Multiple Copies of a Report.

[Guest]

I have a report that is to be distributed to 4 different departments. It was
based on a carbon copy report whose "pink" copy went to Department A, the
"yellow" copy went to Department B, etc.
Is there a way to set up my report so that at the footer of the report so
that it prints out 4 times and on the bottom of each copy is the different
department that copy needs to go to?
I am trying to avoid making 4 individual reports of the same data with the
different footers...and then having to print them all one at a time.
TIA

Example:
Copy 1 Footer reads: Department A
Copy 2 Footer reads: Department B
Copy 3 Footer reads: Department C
Copy 4 Footer reads: Department D

 

[Albert D. Kallal]

I am trying to avoid making 4 individual reports of the same data with the

different footers...and then having to print them all one at a time.

that is a excellent goal, or idea on your part...

the code to do this could look like

DoCmd.OpenReport "altry", , , , , "Department A"
DoCmd.OpenReport "altry", , , , , "Department B"
DoCmd.OpenReport "altry", , , , , "Department C"
DoCmd.OpenReport "altry", , , , , "Department D"

The above simply passes the department name via the open args command.

Then, simply in the reprots on-format event for the reprot footer, you could
go

Me.txtCopy = Me.OpenArgs

Of course, the report footer might actually end in the middle of the
page...so, you likely want to use the reports page footer, and the
department will appear on every page on the bottom if there is more then one
page.

Note that the open-args feature exists for forms...going back to at least
access 97. However, open-args for reports is rather new...I think only
a2003, and a2002 has this feature.....

So, check when you are typing in the docmd.openreprot...and you will see if
inteli-sense shows (allows) the open arges parameter