A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing on 3x5 Rolodex Card Stock



 
 
Thread Tools Display Modes
  #1  
Old May 9th, 2005, 10:11 PM
external usenet poster
 
Posts: n/a
Default 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  
Old May 10th, 2005, 11:44 AM
SA
external usenet poster
 
Posts: n/a
Default

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  
Old May 10th, 2005, 05:18 PM
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 04:00 PM
How do I get colour separated printouts red and black? Karen Publisher 2 November 28th, 2004 12:14 AM
Using Microsoft Word to set-up a Business Card for printing katnoir General Discussion 1 August 14th, 2004 08:02 AM


All times are GMT +1. The time now is 01:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.