Forum Discussion
printing labels multiple times from Access
oneinchsidehop There are several approaches you could take to making this work.
The way I'd tackle it would be to create a form with a multi-select list box, a command button and a text box control.
In the listbox, use the table (or more appropriately a query based on the table) of the items for which you want to print labels. Use the multi-select property to select one or more items to print labels for.
In the textbox control, enter the number of copies you want to print. If you want to print different numbers of copies for different items, you'll have to select them separately, of course.
In the Click event of the command button, run code that prints labels for each of the selected items in that listbox. Use the count in the textbox control to determine how many times to run through the printing function.
According to this I need to:
Create a query that selects the records to be printed (will usually be based on invoice number) and then duplicates records in the query based on the value in the reprints field?
That query would be run/controlled by the above form that features the multi-select list box, command button and the text box control.
So then:
list box selects records
text box control specifies number of repeats
command button runs the query
Am I following you correctly?
That's correct. If you haven't tackled something like this before, perhaps we'll find time this morning to put a simple demo together,