• Increment Number on Label (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Increment Number on Label (2000)

    • This topic has 8 replies, 4 voices, and was last updated 21 years ago.
    Author
    Topic
    WSstevecox4444
    AskWoody Lounger
    May 14, 2004 at 5:37 am #404900

    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

    Reply | Quote
    Viewing 3 reply threads
    Author
    Replies
    • WSjohnhutchison
      AskWoody Lounger
      May 14, 2004 at 6:24 am #827092

      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

      Reply | Quote
    • WSjohnhutchison
      AskWoody Lounger
      May 14, 2004 at 6:24 am #827093

      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

      Reply | Quote
    • WScslauenwhite
      AskWoody Lounger
      May 15, 2004 at 2:07 pm #827180

      Edited by WendellB to activate links to the MSKB article – see Help 19
      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
      Microsoft Knowledge Base Article 299024
      http://support.microsoft.com/default.aspx?…kb;EN-US;299024%5B/url%5D
      I hope that this gives you some ideas to figure out your little problem.

      Reply | Quote
    • WScslauenwhite
      AskWoody Lounger
      May 15, 2004 at 2:07 pm #827181

      Edited by WendellB to activate links to the MSKB article – see Help 19
      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
      Microsoft Knowledge Base Article 299024
      http://support.microsoft.com/default.aspx?…kb;EN-US;299024%5B/url%5D
      I hope that this gives you some ideas to figure out your little problem.

      Reply | Quote
    Viewing 3 reply threads
    Reply To: Increment Number on Label (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.