Want to Print 6 cards 2x3 - front & back have to match. Can do wi.

[Guest]

Trying to get Access to print 6 cards per 8.5x11 sheet (200+) cards. Cards
have info on front and back. Have it set up but I need to be able to print
mirror image on front and back.

Front Back
1F 4F | 4F 1F
2F 5F | 5F 2F
3F 6F | 6F 3F

I can do it with Excel, but it will be very difficult to change data for the
future.

 

[Terry]

Dan,

I think this would be very difficult to do in an Access
report. I have played around trying to do similar printing
and given up.

There is a product called "printshop mail" which will do
this relatively easily. Depends on whether it is worth the
money (and learning curve) for this report.

HTH

Terry

 

[PC Datasheet]

You can use two label reports. Base the first report on a query that gives
you the data for the front of the cards. Base the second report on a query
that gives you the data for the back of the card. Put your sheets in your
printer and print the front of the cards using the first report. Flip your
sheets over, put them back in the printer and print the back of the cards
using the second report.

Two things you have to take into account ---
1. When you print the front of the cards, card1 is at the top left. When
you flip the sheet over, card1 is at the top right. You need to take this
into account in query2.
2. When you put the sheets back into the printer to print the back of the
cards, make sure you start printing on sheet1 again

 

[Guest]

Thanks for the help

Dan

Dan,

I think this would be very difficult to do in an Access
report. I have played around trying to do similar printing
and given up.

There is a product called "printshop mail" which will do
this relatively easily. Depends on whether it is worth the
money (and learning curve) for this report.

HTH

Terry

 

[Guest]

Thanks for teh help.

Dan

You can use two label reports. Base the first report on a query that gives
you the data for the front of the cards. Base the second report on a query
that gives you the data for the back of the card. Put your sheets in your
printer and print the front of the cards using the first report. Flip your
sheets over, put them back in the printer and print the back of the cards
using the second report.

Two things you have to take into account ---
1. When you print the front of the cards, card1 is at the top left. When
you flip the sheet over, card1 is at the top right. You need to take this
into account in query2.
2. When you put the sheets back into the printer to print the back of the
cards, make sure you start printing on sheet1 again

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[Guest]

I have the same problem. Your answer is OK but how can I set up the fields in
query2 to take into account that the data in the left column shoud be at the
right of the sheet and that the data in the right column should be at the
left ? Thank you !