If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Numbering Labels
I have a form that the user uses to select several items associated with a
particular Job Number. If Item A has a quantity of 25, I need to print 25 labels 1 of 25, 2 of 25, 3 of 25 ...... If Item B has a quantity of 5, I need to print 5 labels 1 of 5, 2 of 5, 3 of 25 .......... The number of Items, and quantities, will not always be the same. The user needs to click a button just once to print all labels. Could somebody point me in the right direction to print numbered labels for several records? Thanks |
#2
|
|||
|
|||
Numbering Labels
Not hard. If you open the property sheet for the detail section, you can set
the Force New Page property to After Section. Then you can add the page numbers and number of pages to number the labels. Where you find it depends on your version of Access. -- Dave Hargis, Microsoft Access MVP "JB" wrote: I have a form that the user uses to select several items associated with a particular Job Number. If Item A has a quantity of 25, I need to print 25 labels 1 of 25, 2 of 25, 3 of 25 ...... If Item B has a quantity of 5, I need to print 5 labels 1 of 5, 2 of 5, 3 of 25 .......... The number of Items, and quantities, will not always be the same. The user needs to click a button just once to print all labels. Could somebody point me in the right direction to print numbered labels for several records? Thanks |
#3
|
|||
|
|||
Numbering Labels
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "MultipleLabelsOffsetBatch2.mdb" which illustrates how to do this. You can download it for free he http://www.rogersaccesslibrary.com/f...ts.asp?TID=519 -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "JB" wrote in message ... I have a form that the user uses to select several items associated with a particular Job Number. If Item A has a quantity of 25, I need to print 25 labels 1 of 25, 2 of 25, 3 of 25 ...... If Item B has a quantity of 5, I need to print 5 labels 1 of 5, 2 of 5, 3 of 25 .......... The number of Items, and quantities, will not always be the same. The user needs to click a button just once to print all labels. Could somebody point me in the right direction to print numbered labels for several records? Thanks |
#4
|
|||
|
|||
Numbering Labels
Thanks for your help.
Roger, I successfully modified your code. It works perfectly. Thanks again "JB" wrote: I have a form that the user uses to select several items associated with a particular Job Number. If Item A has a quantity of 25, I need to print 25 labels 1 of 25, 2 of 25, 3 of 25 ...... If Item B has a quantity of 5, I need to print 5 labels 1 of 5, 2 of 5, 3 of 25 .......... The number of Items, and quantities, will not always be the same. The user needs to click a button just once to print all labels. Could somebody point me in the right direction to print numbered labels for several records? Thanks |
Thread Tools | |
Display Modes | |
|
|