Am I just not seeing the answer to this?

I am trying to print out labels for products. What I would need to do to print the quanity of labels to match the number of products. Example: Customer purchases 3 items, I need to print 3 labels for that order. Assume that a customer purchases 3 of Item A, 2 of Item B, and 6 of Item C. I would need the customer info to print on all the labels, then specifically for Item A: 1 of 3, 2 of 3, and 3 of 3, etc.

Any ideas. So far anytime I have posted anything to this forum, I do not receive any ideas or feedback. Am I not making the questions clear enough??
Thanks
Nadine Hendrickson

How are you printing the labels? What software are you using/label type/etc? Have you tried to create a temporary recordset with the label information you want and point the labels to that?

Always glad to help!
t_neustel

The labels are printing as a report, because I have a one to many relationship between the item code and the multiple line remarks that are tied to that order and that item code. (These remarks also print out on the label). I am using Access 2000 and am using general purpose 3" x 5" white labels on a M4206 printer.

Ultimately what this is for is our door manufacturing facility. Where we want the customer's name, jobsite address, then the door information (handing, size, material, hardware type, hinge type, etc) and there maybe only 1 of door A, 6 of door B etc.

And I am trying to get the software to print only one label for Door A, but 6 copies for door B. These quantities are in the recordset and print on the label, but trying to get it to automatically repeat until the quanity printed matches the order quanity is eluding me. Any ideas?

P.S. My data is live data through an ODBC link with ECS PRO.

Hi NadineH,

I am not familiar with ECS Pro...but I think that your best option is to populate another recordset with exactly what you want (if you want 4 labels for door B than there will be 4 rows with the same data). I can remember developing a similar application but we utilized BarTender software and I found a setting where the ODBC would look at a qty field in my Access DB and print that amount of labels. Since you are utilizing an Access Report to generate the labels you may be able to use the Sorting/Grouping feature of the report...

Hope this helps...
t_neustel

I am familiar with Bartender, and already have some software written for our Retail locations. One of the main problems I am running into is that there are varying numbers of line remarks for each line item. Sometimes there are not any. So I am not actually using the "label" format. The thought occurred to me to try using a print command in the code. I thought I had run across something somewhere that you could specify certain pages to print and the quanity. I wonder if that it can be further configured to have the page # = line # and the print quanity = Item Quanity. Do you have any experience with that command. I haven't had the opportunity to start researching that avenue yet.

Thanks for your help!
Nadine