If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Printing report in booklet format
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 |
#3
|
|||
|
|||
Printing report in booklet format
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 . |
#4
|
|||
|
|||
Printing report in booklet format
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: |
#5
|
|||
|
|||
Printing report in booklet format
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: . |
Thread Tools | |
Display Modes | |
|
|