repeat a page in a report

Jhitch

Registered User.
Local time
Today, 19:01
Joined
Nov 26, 2002
Messages
42
How can i repeat a page in a report including the page header, detail, footer etc. I have code that will repeat the detail of a report but it doesnt work for the whole page. i have a report of 50 students, 1 per page. if the student needs a duplicate report i want to just repeat that students report page.
 
Filter the report on either the student's ID number (assuming their is one) or the student's name. Using the latter may be risky because it's possible to have two "John Smith"s in there. If you want to parameterize this (where you're prompted for the student's ID or name), just make a copy of your existing report, add a field called "StudentFilter" (or something else easily identifiable), place it in the form's header, and make it invisible. In the report's Record Source property, the source changes from:

"SELECT * FROM tblStudents"

(or whatever it is now) to:

"SELECT * FROM tblStudents WHERE StudentID = " & [StudentFilter];

If you're using the student's name or if the ID has alphanumeric characters in it, add single quotes to that, like this:

"SELECT * FROM tblStudents WHERE StudentID = '" & [StudentFilter] & "';"
 
i dont think i have explained this very well. I dont need to filter the report. The report prints out a page for each student. Each page has a group header, detail containg exam grades and group footer. I have a field on the report that indicates if the student needs two copies of the same page. I want at run time to print an extra copy of a page if the field indicates it. I have tried all combinations of nextrecord, movelayout and print but the best i can get is the detail section repeated on the same page without a group footer and a complete copy of the page but without the detail section!!!!!! I have used code that works for reports with only a detail section but cannot get it to work when there is headers and footers.
 
Jhitch...I'm facing this exact issue. did you ever get it resolved?

Thanks,
Gary
 

Users who are viewing this thread

Back
Top Bottom