Batch Label Printing

  • Thread starter Thread starter Debra Farnham
  • Start date Start date
D

Debra Farnham

I apologize for cross-posting but I think my question falls under both
categories.

Access 2000 on Win2k OS

Background:
I have two listboxes on an unbound form. The user can select jobs that
require labels from one listbox (lstJobs) that add them to the second
listbox (lstLabels). There are two fields in the rowsources for each of the
listboxes: autJobID and strPieces. I have successfully coded the boxes to
work the way I want them to.

Problem:
When the user hits the print button, I need the label report that I have
created (specific to a brand name of thermal printer) to print out the
number of labels as indicated in the Pieces field for each job listed in
lstLabels.

Am I trying to achieve the impossible or does anyone have a better solution.

Ultimately, I want the user to pick and choose one or many jobs that require
labels and have the labels print the number of copies as specified in the
strPieces field. I have no need to track what has printed and what has not.

TIA for anyone who may be able to assist.

Debra
 
See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article describes how to reliably print a quantity of a label. You can
combine that information with a WhereCondition of the OpenReport action to
print out the quantity of the item selected in the list box.

If lstLabels is a multi-select list box, you will need to loop through its
ItemsSelected collection to build up the string for the WhereCondition. The
IN operator will be useful.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Debra Farnham said:
I apologize for cross-posting but I think my question falls under both
categories.

Access 2000 on Win2k OS

Background:
I have two listboxes on an unbound form. The user can select jobs that
require labels from one listbox (lstJobs) that add them to the second
listbox (lstLabels). There are two fields in the rowsources for each of the
listboxes: autJobID and strPieces. I have successfully coded the boxes to
work the way I want them to.

Problem:
When the user hits the print button, I need the label report that I have
created (specific to a brand name of thermal printer) to print out the
number of labels as indicated in the Pieces field for each job listed in
lstLabels.

Am I trying to achieve the impossible or does anyone have a better solution.

Ultimately, I want the user to pick and choose one or many jobs that require
labels and have the labels print the number of copies as specified in the
strPieces field. I have no need to track what has printed and what has
Click to expand...
not.
 
Allen ... you are a godsend. I am going to attempt your solution
immediately.

Thank you sooo much!

Debra
 
Back
Top