[AccessD] Post Card Printing

HI Mike:

I had a similar printing problem with printing ID cards. The picture, ID and
name were printed on the front and the disclaimer, name and place for
signature were printed on the back. The pictures and name/signature had to
line as there could be up to 60 printed at one time. 

Simply print the first side, then prompt the user to place the half
completed cards flipped over in the card bin. Then the back would print. The
trick was the same recordset/report was being used but on the second pass,
the report was re-set to the first record, all the 'front' information was
being turn-off/hidden and the 'back' information was being
turned-on/unhidden. (All the code was in the single Access report.)

It worked great. I could send you the report and its imbedded code but it
used an odd 4 colour film printer/driver and you may have difficulty getting
it to display.

Jim   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: February 2, 2006 7:22 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Post Card Printing

 

I'm wondering if any one knows of a way that I can get post cards to
print from the database.  Here is what I am attempting to do but it is
not working.  I print the front of the card with the return address and
the address of the customer (4 per page).  Than what I want to be able
to do is flip the card stock over and print the customer billing data on
the back.  Currently the columns are set up to go across and than down
for printing.  Is there a way that I can get the columns to print across
the bottom and than up?  The problem is when I turn over the card stock
than the names and detail do not match up, they are backwards, because
of course when you flip the card stock over the first record is at the
bottom of the page instead of the top.

Anybody have any ideas?

Thanks in advance for any ideas,


Mike Gowey  MCSA, MCDST, A+, LME, NET+
Team Leader - SouthEast Region
Information Systems Unit



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com