Barcode Scanning inventory

[tikki]

Hello.

I have got a job from my boss. this is to wright down parts number and quantity of each part number i have 5 pallets with car brakepads to wright down. so a lot of work.


So my plan was simpel in my head. but difficult to do.

I have a excel files with all the products and barcodes for my company. like in picture.


So what i want to happen is. when i scan a barcode it would look like this in picture below, and if i scan same barcode two or more times i would like the number for that product to +1 each time it scans.
And when a product scans and it get in to the form it automaticly jumps to the next line and is ready for new scan.


How do i do this in excel or acsess or other platforms that is more suited. ??+
Thanks.

[ranman256]

a form (either xl or access) would accept the scan and add 1 to the list via:

if keyed access tbl: run append qry to add the BC, then run Update Qry to increment Qty

if using xl, find BC scanned, if not found, add, then increment Qty.

[June7]

Quantity on hand should really be calculated, not saved into table. Review http://allenbrowne.com/AppInventory.html