|
| 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
February 25th, 2006, 07:54 PM
posted to microsoft.public.access.reports
|
|||
|
|||
print the survey sheets for the number of student enrolled in a class for all classes
I need you help. I am trying create very simple hardcopy survey print
database. But i got stuck on the area where i need to print number of copies of the report based upon the value on the field. Basically, I am trying to print the survey sheets for the number of student enrolled in a class for all clases. Class A with 10 student enrolled, print 10 copies of the survey, class B with 5 student, print 5 copies of the survey. I need to include teacher and class information at the top of the report so i can track surveys. EX: CrsCode Title Teacher Enrollmnt CS Computer Sci Mr. Smith 5 BIO Biology Ms. Smith 2 EDU Education Mr/Ms Smith 3 So print all survey would print 5 copies of survey with CS title and teacher name at the top and proceed to next. I can print a record with following code but how do i print all? Docmd.printout , , , , Enrollmnt thanks 
|
|
#2
February 26th, 2006, 02:05 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
print the survey sheets for the number of student enrolled in a class for all classes
One method used to print more than one copy of a report is to create a table
of numbers with a single numeric field and values 1 - whatever tblNumbers Num 1, 2, 3, 4, .... Add this table to your report's record source and place the Num field in the query grid. Set the criteria under the [Num] field to =[The value on the field] -- Duane Hookom MS Access MVP -- "sa sa" wrote in message ups.com... I need you help. I am trying create very simple hardcopy survey print database. But i got stuck on the area where i need to print number of copies of the report based upon the value on the field. Basically, I am trying to print the survey sheets for the number of student enrolled in a class for all clases. Class A with 10 student enrolled, print 10 copies of the survey, class B with 5 student, print 5 copies of the survey. I need to include teacher and class information at the top of the report so i can track surveys. EX: CrsCode Title Teacher Enrollmnt CS Computer Sci Mr. Smith 5 BIO Biology Ms. Smith 2 EDU Education Mr/Ms Smith 3 So print all survey would print 5 copies of survey with CS title and teacher name at the top and proceed to next. I can print a record with following code but how do i print all? Docmd.printout , , , , Enrollmnt thanks
|
|
#3
February 27th, 2006, 12:50 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
print the survey sheets for the number of student enrolled in a class for all classes
Thanks Duane, for saving my monday.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
| one-to-many-to-many relationships | Ricoy-Chicago | General Discussion | 6 | March 7th, 2005 02:31 PM |
| Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
| How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
| My Schedule: Am I dreaming? | JEM | Links and Linking | 2 | May 22nd, 2004 02:53 AM |
Linear Mode
