Forum Discussion
printing labels multiple times from Access
I'm setting up a database in Access to track inventory in a retail store, the main purpose will be to print labels for new items as they are received. I've figured out how to write a report that wil...
I have very little experience with this and I'm not a programmer at all, so please bear with me.
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?
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,