Thanks, Ettiene.
That was a good idea. It finally resolved itself as a coding issue.
I was proceeding under a false assumption, namely that the data entry sheet with the barcodes contained only part numbers that existed in the master spreadsheet I was filling in quantity data for.
Turns out...
This freaking me out!
I have a simple user form:
1) scan value with CCD barcode scanner
2) retrieve description with SQL
3) position to quantity field, key quantity
4) update quantity value to row found using lookup code
5) clear old input values and return to barcode input...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.