Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Increment Number on Label (2000)

    I want to have a database which has names and job numbers then prints out preformatted labels with an incrementing number on it - eg I decide to print 100 labels to be stuck on a delivery to Fred Nurks, job 27. The first label would be 1 with Freds Address and job 27, the second would be 2 with Freds Address and job 27 etc
    Any suggestions appreciated
    TIA
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Increment Number on Label (2000)

    There are perhaps two parts to your question. I am not sure if you are asking both.

    You can print multiple copies of the same label, and number them using the Print event of the Detail section of the labels report, by using the PrintCount property of the report.

    Assuming the number of labels is specified on a form, say frmLabelsCriteria, use this:

    if Printcount < forms!frmLabelCriteria!txtNumberofLabels then
    me.NextRecord = false
    me!txtCount =printCount
    end if


    where txtCount is an unbound text box on the labels
    Regards
    John



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

    Re: Increment Number on Label (2000)

    John,

    Very Clever. Thanks.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Increment Number on Label (2000)

    Thanks all very much for the great help
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  5. #5
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Increment Number on Label (2000)

    <font color=4682b4> Edited by WendellB to activate links to the MSKB article - see <!help=19>Help 19<!/help> </font color=4682b4>
    Here is an article from Microsoft that might help you out a lot. it is not on Increment numbering but it is on how to print multiple copies of the same mailing label, and how to use a partially used page where only some of the labels are available.
    Microsoft Knowledge Base Article - 299024
    <!mskb=299024>Microsoft Knowledge Base Article 299024<!/mskb>
    http://support.microsoft.com/default.aspx?...kb;EN-US;299024
    I hope that this gives you some ideas to figure out your little problem.

Posting Permissions

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