Repeating Labels with Access

[JWT]

Hello,
I want to solicit an item from an inventory Query and use Avery 30-label sheet in Reports/ Label Wizard to print 30 of the same item. I have set up a “dummy” table as decried by Pat Hartman posted 12-4-01, but I have not been able to get it to repeat. This is how I have my query set to display only one part by stock number:
Like [Stock Num]+"*" And Like [Stock Num]+"*"

If Pat or anyone can help with this set up please reply.
Thank you, JWT

 

[Chris RR]

Have you looked at the Microsoft Knowledge base article, "ACC2000: How to Skip Used Mailing Labels and Print Duplicates (Q231801)"? This shows you how to ask the user for the number of labels to print. I've used it in a number of systems.

P.S. The Knowledge base is at support.microsoft.com

 

[JWT]

Thank you Chris,
About: ACC2000: How to Skip Used Mailing Labels and Print Duplicates (Q231801) I had set this up about a week ago and hoped it would work. With the first Label report I would click on and put in the box my stock number only one label would appear. With this (Q231801) in place I got the first box for how many to skip then the next box for how many to print and then the last box to put in the stock number again only one label appeared. I think this should ask for the stock number first but not able to get this set up or even if it will work that way.
My query pulls information from two tables to show three lines on a label report would like to have (Q231801) work. This would give me full control over labels printed.

 

[Chris RR]

Actually, I think that you are getting the message boxes in the right order. Are you certain that you have all the setup correct? It's really easy to forget a step.

If you are certain that you have the OnPrint set up in the detail section of your labels (and not anywhere else) and the OnOpen set up for the entire report...and you've added the header and footer... Then I'd set some breaks in the code and walk though the code line by line.

 

[JWT]

Wish I could get this to work but on luck so far. I ‘m hoping that I can get a step by step lay out of how to set up a way to pick one item to print and be able to skip or print what I need. When I remove the section that allows me to select just one item to print it works but it starts at the beginning of my inventory list. That is why I asked about the order that the message boxes that ask for my in put. Is there away to select the item/label to print first then tell how many to skip & how many to print???
Again thank for your help, JWT


[This message has been edited by JWT (edited 12-14-2001).]

[This message has been edited by JWT (edited 12-14-2001).]

 

[Chris RR]

In your original post, you have this code:
Like [Stock Num]+"*" And Like [Stock Num]+"*"
Why do you have the Like showing up twice? Are there other criteria in the query?

Try building a form where the user enters the criteria, then hits a "print labels" button. Get this form, query and report working without any multiple-label functionality. This way, you'll not generate any message box of your own to run the labels.

Then try adding the the Knowledge Base changes.

Sorry that I have been so inconsistent about following this thread. In the wake of 9/11, I've been RIF'd (reduction in force has happened...to me and quite a few others at my former company).

 

[chuckgoss]

JWT...I hope I understand your problem correctly. This is what I did.

I had a need to print multiple labels based on the quantity typed (listed) in a field on a form. The query already had the record pulled up that provided all the details for my label. I use a loop to print multiple reports (labels) as follows:

Dim Counter As Integer
Counter = 0
Do Until Counter = Me![ctlQuantity]
DoCmd.OpenReport "Labels", acViewNormal, , "[Index]=" & Me.Index
Counter = Counter + 1
Loop

Works every time. The control with the quantity in it is called ctlQuantity, and my label is called Labels.

chuck