different footer text on each copy

  • Thread starter Thread starter Paige
  • Start date Start date
P

Paige

Hello,

I have a report that generates from information on a
form. Works fine, never any problems. What I want to do
is, when I send that form to the report to print, I want
two things to happen: (1) three copies of the report
should print; (2) on copy 1 the text "student copy", on
copy 2 "department copy", and on copy 3 "CAS copy". The
report is only one page in length and contains information
in the page header, body, and page footer.

Can anyone provide any insight? I am not sure if the
information should go in the code for the form (user
clicks "print" button) or in the report footer.

Thanks!
-paige
 
If it were me (and I'm no Access guru by any stretch), I would make copies
of the report and change the footers the way you want them. Then, under the
macros tab, make a macro that runs the reports for you (no coding required)
in succession. Then, have the print button run that macro.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
 
One method

Create a new table.
tblPrintCopies
CopyNumber
FooterText

Add three records
1 Student Copy
2 Department Copy
3 CAS Copy

Add that table to your query, but don't join it to any other tables. This will
cause three records to appear for each one you have now.

Now Group by CopyNumber as the last sort/group in the sorting and grouping
dialog and add a Group Footer
Set the Group Footer's force New Page property to After Section
Add a control the page footer that has FooterText as its control source.

That should do it.
 
John: I was trying to accomplish the same thing, using your suggestion, but when I add the table to my existing query (the tblPrintCopies is not joined), I get an access message about "ambiguous outer joins". (The query was happy before adding the new non-joined table). Any suggestions?
 
Back
Top