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 on 3x5 Rolodex Card Stock
Hello Everyone,
I have a report based on a query ( 2 tables: one is tblEmployee the other is tblCars) The query lists an employee with 1 to 6 cars (1 to Many relationship). I have precut 3x5 card stock from Rolodex and have setup the report page format to print 2 columns with 2 rows to match the cardstock. I have been able to print an employee whether 1 or 6 on each card but not on a single 3x5 card listing all the cars information line by line. Now I have a Group Header (Height .75") for Name and phone number. I want to list in the details section their year, make, and model on separate lines. I cannot get the report to go to the next section or more importantly next card to print the next person and their respective cars. The next person simply prints right after the last detail record, not onto the next card. I have played with the various properties but to no avail. Can any one help. - Tom |
#2
|
|||
|
|||
Tom:
Make sure that you've got the paper size set properly File - Page set up. You may need to create a custom paper size in Windows to match your card stock. This can be done by opening the printers folder and from the File - Server Properties menu item creating the new paper size then going back to Access to select that size. -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg Tom T wrote in message ... Hello Everyone, I have a report based on a query ( 2 tables: one is tblEmployee the other is tblCars) The query lists an employee with 1 to 6 cars (1 to Many relationship). I have precut 3x5 card stock from Rolodex and have setup the report page format to print 2 columns with 2 rows to match the cardstock. I have been able to print an employee whether 1 or 6 on each card but not on a single 3x5 card listing all the cars information line by line. Now I have a Group Header (Height .75") for Name and phone number. I want to list in the details section their year, make, and model on separate lines. I cannot get the report to go to the next section or more importantly next card to print the next person and their respective cars. The next person simply prints right after the last detail record, not onto the next card. I have played with the various properties but to no avail. Can any one help. - Tom |
#3
|
|||
|
|||
Steve,
First, thank you for replying. The Card Stock is on standard 8 1/2 x 11 paper. The Rolodex cards are laid out on the sheet 2 across and 2 down for a total of 4 cards per sheet in landscape mode. In landscape mode both top and bottom margins are 1 1/4" and left and right margins are 1/2". I did create a "3x5 Card" custom within the Server Properties but that does not work for the 8 1/2 x 11 sheets from Rolodex. I did modify the GroupHeader... Properties... "New Row or Col" to "Before Section" and that at least printed the top 2 cards in the first row (landscape mode). It would be a terrible waste of paper as there are 246 total pages in the report. Do you have any other Ideas? - Tom "SA" wrote in message ... Tom: Make sure that you've got the paper size set properly File - Page set up. You may need to create a custom paper size in Windows to match your card stock. This can be done by opening the printers folder and from the File - Server Properties menu item creating the new paper size then going back to Access to select that size. -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg Tom T wrote in message ... Hello Everyone, I have a report based on a query ( 2 tables: one is tblEmployee the other is tblCars) The query lists an employee with 1 to 6 cars (1 to Many relationship). I have precut 3x5 card stock from Rolodex and have setup the report page format to print 2 columns with 2 rows to match the cardstock. I have been able to print an employee whether 1 or 6 on each card but not on a single 3x5 card listing all the cars information line by line. Now I have a Group Header (Height .75") for Name and phone number. I want to list in the details section their year, make, and model on separate lines. I cannot get the report to go to the next section or more importantly next card to print the next person and their respective cars. The next person simply prints right after the last detail record, not onto the next card. I have played with the various properties but to no avail. Can any one help. - Tom |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
printing web address in card style?? | IS | Contacts | 10 | May 7th, 2005 02:18 AM |
How do I print on card stock paper???? | Jer | General Discussion | 2 | January 17th, 2005 03:00 PM |
How do I get colour separated printouts red and black? | Karen | Publisher | 2 | November 27th, 2004 11:14 PM |
Using Microsoft Word to set-up a Business Card for printing | katnoir | General Discussion | 1 | August 14th, 2004 08:02 AM |