Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / February 2005

Tip: Looking for answers? Try searching our database.

Continuous printing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tikal_traveler - 06 Feb 2005 23:51 GMT
I'm trying to use a report which prints out 4 5X3 cards per book entry.  
This would work fine for 8 1/2" by 14", but for the card paper I have, it
needs to be 8 1/2" by 11" or 8" by 12".  So, when I print out the cards, it
prints out 3 for the first page and 1 for the second and starts the next
entry on the third page.  Does anyone know how to print continuously - start
the next series of 4 to print on the second
page?  Thank you.
Duane Hookom - 07 Feb 2005 04:00 GMT
Have you considered printing them in landscape where you could get 4 per
page? Also, we don't really have any idea how you are arriving at 4 copies.
Have you just copied the same set of controls 4 times?

Signature

Duane Hookom
MS Access MVP

> I'm trying to use a report which prints out 4 5X3 cards per book entry.
> This would work fine for 8 1/2" by 14", but for the card paper I have, it
[quoted text clipped - 5 lines]
> the next series of 4 to print on the second
> page?  Thank you.
tikal_traveler - 10 Feb 2005 01:07 GMT
Thanks for your response.  It's a library card program I'm working on and
there are 4 cards per book.  One for the subject, one for the title, one for
the author, and one for the shelf list number.  Alot of the controls are
repeated.  I blocked out 4 5X3 spaces together on one report.  As far as
printing them in landscape, how could you configure Access to print 4 per
page?

> Have you considered printing them in landscape where you could get 4 per
> page? Also, we don't really have any idea how you are arriving at 4 copies.
[quoted text clipped - 9 lines]
> > the next series of 4 to print on the second
> > page?  Thank you.
Duane Hookom - 10 Feb 2005 03:31 GMT
I would set up a landscape report with two columns and the detail section
the size of a single card. Create a table "tblNums" with one field "Num" and
four values 1, 2, 3, and 4. Add this table to your report's record source
and don't create any join lines. Sort and Group your report by something
other than the Num field. This will create 4 copies of each record from your
original table/query.

Signature

Duane Hookom
MS Access MVP

> Thanks for your response.  It's a library card program I'm working on and
> there are 4 cards per book.  One for the subject, one for the title, one
[quoted text clipped - 21 lines]
>> > the next series of 4 to print on the second
>> > page?  Thank you.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.