This might be a VERY broad question but will aid me in the right direction. After a customer orders there will be a picking list generated for the picker to collect the items on the list.
Our products could be in multiple locations with multiple quantities. (Generally no but could). I have a table called ProdLocations. It has fields:
ProductId(found in the Products Table)
LocID (found in the Locations Table)
I would like for Access to evaluate all the Locations and Quantity in those locations for that product on the order.
Then decide on a location (LocID) that best fits and place it on the pickers list.
here is code you can put into a general module that will help set control RowSources depending on what is entered. (CODE)ProdLocID will be a combobox that stores ProdLocID and shows Location, Qty, (and
To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…