Printing report in booklet format

I have created application to populate and print report cards. Recently the
school has purchased a new Xerox printer that allows them to print the report
cards in booklet format. In the current application, you select the home room
number that you want to print from a form and all the report cards are
printed for each student - i.e. the whole file is printed as 1 report / 1
booklet. With the new printer, I need to create a break so that the printer
recognizes each student as a seperate file and will print this as 1 booklet.

I am hoping that this problem can be solved with our writing code as that is
not my strength. Any help would be appreciated.
--
JBeskid

I can't think of a way other than to use VBA and loop through the students
printing one report per student.

That code should not be too difficult to do. I might take a stab at it this
weekend, if you will post the current query that you are using as the source
for your current report.

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

JBeskid wrote:
I have created application to populate and print report cards. Recently the
school has purchased a new Xerox printer that allows them to print the report
cards in booklet format. In the current application, you select the home room
number that you want to print from a form and all the report cards are
printed for each student - i.e. the whole file is printed as 1 report / 1
booklet. With the new printer, I need to create a break so that the printer
recognizes each student as a seperate file and will print this as 1 booklet.

I am hoping that this problem can be solved with our writing code as that is
not my strength. Any help would be appreciated.
--
JBeskid

Thanks John. Below is the Sql you requested. Any help would be greatly
appreciate.

SELECT T_Student.HR, T_Student.Lname, T_Student.Fname, T_Student!Fname & " "
& T_Student!Lname AS Name, T_Student.Grade
FROM T_Student
GROUP BY T_Student.HR, T_Student.Lname, T_Student.Fname, T_Student!Fname & "
" & T_Student!Lname, T_Student.Grade
HAVING (((T_Student.HR)=[Forms]![F_ReportsCards]![cmbHR]) AND
((T_Student.Lname) Like [Forms]![F_ReportsCards]![cmbStudent] & "*"))
ORDER BY T_Student.HR, T_Student.Lname;
--
JBeskid


"John Spencer" wrote:

I can't think of a way other than to use VBA and loop through the students
printing one report per student.

That code should not be too difficult to do. I might take a stab at it this
weekend, if you will post the current query that you are using as the source
for your current report.

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

JBeskid wrote:
I have created application to populate and print report cards. Recently the
school has purchased a new Xerox printer that allows them to print the report
cards in booklet format. In the current application, you select the home room
number that you want to print from a form and all the report cards are
printed for each student - i.e. the whole file is printed as 1 report / 1
booklet. With the new printer, I need to create a break so that the printer
recognizes each student as a seperate file and will print this as 1 booklet.

I am hoping that this problem can be solved with our writing code as that is
not my strength. Any help would be appreciated.
--
JBeskid
.

Looks like too many quotes - Sorry I thought I tested this better than I did.

strWhere = "HR = """ & rst!HR & """" & _
" AND Lname = """ & rst!Lname & """" & _
" AND FName = """ & rst!Fname & """"

IF you use Debug.Print strWhere in your code you should see
HR="700-01" AND LName="Byren" And FName="William"

If you see something different, you will need to play with the strWhere to get
the results correct.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

JBeskid wrote:

Thanks John. I just found the problem and everything seems to be working as
planned. You saved my life. There is a special place for you in heaven.
--
JBeskid


"John Spencer" wrote:

Looks like too many quotes - Sorry I thought I tested this better than I did.

strWhere = "HR = """ & rst!HR & """" & _
" AND Lname = """ & rst!Lname & """" & _
" AND FName = """ & rst!Fname & """"

IF you use Debug.Print strWhere in your code you should see
HR="700-01" AND LName="Byren" And FName="William"

If you see something different, you will need to play with the strWhere to get
the results correct.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

JBeskid wrote:
.