Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplicate mailing labels (Access 2000)

    Good Morning to All,

    I have created a custom mailing label and what to be able to print several labels with the same data. I'm sure this has been ask before, but my search was unable to find anything.

    Thank You,
    jim

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

    Re: Duplicate mailing labels (Access 2000)

    One way is to create another table that contains sequential numbered records (the records don't need to have any other fields). Then join your existing label source with this new table. Since there are no "matching" fields, you will get a Cartesian Join, which means every record in your label source will join with 1 record from the new table.

    If your Number table contains 50 records, then you will be able to print up to 50 labels per original label source. You can restrict the number of labels by putting a selection critieria on the Number field, something like this:

    <=[How many labels do you want? (1-50)]

    When you run the label report, Access will pop an input box using the string within the brackets above as a prompt.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate mailing labels (Access 2000)

    In this KB article, you can download a report sample database for Access2000.
    Look at the report "How to skip used mailing labels and print duplicates"
    It's exactly what you want.
    Francois

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate mailing labels (Access 2000)

    Thank You for your assistance. Yes the Q23185 gave me just what I needed.
    Jim

  5. #5
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate mailing labels (Access 2000)

    Thanks Mark,
    Will try this out. Have also been pointed to MS Q23185.

    Thaks Again
    Jim

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

    Re: Duplicate mailing labels (Access 2000)

    Did you actually find Q23185? I couldn't.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate mailing labels (Access 2000)

    Mark,
    the right number is Q231851. The link is on my previous post in this thread.
    Francois

  8. #8
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate mailing labels (Access 2000)

    Mark,
    Didn't mean to lead you astray. The number should have been Q231851
    Sorry
    Jim

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

    Re: Duplicate mailing labels (Access 2000)

    Ah, found it. Thanks.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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