Jan 05 2022 12:01 PM
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 will list each record as a label but I don't know how to tell it to only include ___ items (new listings or records searched for and tagged) in the report. More importantly, I need to be able to print multiple copies, say 96, of one record, only a few of others and just one of most.
Jan 05 2022 12:46 PM
@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.
Jan 05 2022 02:10 PM
On my website, I have a demo database which includes the use of a mult-select list box. It's only partially applicable to your requirement, but you can use that segment as a template for what you need to do.
Jan 06 2022 04:46 AM
Jan 06 2022 05:33 AM
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,
Jan 06 2022 01:56 PM
Jan 07 2022 04:15 AM
Jan 07 2022 04:22 AM
here is another sample.
Jan 07 2022 05:28 AM
Jan 07 2022 06:38 AM
Jan 07 2022 08:08 PM
you can Filter the records, then add the quantity.
items with 0 quantities are not included in the report.