Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Multiple Labels (XP/2K)

    How can I print sequentially multiple copies of a label? i.e. I want to print 4 copies of each mailing label one after the other on the same sheet, before printing the next one.
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Labels (XP/2K)

    Microsoft has a solution for this: see HOW TO: Skip Used Mailing Labels and Print Duplicates in Access 2000. They also have a report samples database in which this is demonstrated. You'll find a link for downloading this database at the bottom of the KB article.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple Labels (XP/2K)

    thanks

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Multiple Labels (XP/2K)

    Zave,

    Another solution is to set up another table (let's call it tblCopies) which contains nothing more a single integer field (call this field [CopyNo]). Then add a bunch of records to tblCopies, sequentially numbering them from 1 to perhaps 10 (allowing for up to 10 copies per label) Now, add this table into your query that produces the labels (let's assume this is just a single table to make this example more understandable). Since there is no common fields, a cartesion product of the 2 tables is created, in which each record from your data table is linked with every record in tblCopies.

    Finally, you need a way to place a selection criteria on the CopyNo field. You can make it a parameter query (in which case the computer will stop and pop a box asking for "The number of copies to print?"), or you can include it in a WHERE clause in your OpenReport method to start the label report.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple Labels (XP/2K)

    I tried this and it works like a charm. Thanks for the info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •