asset tracking help

[munkeyroot]

Hi i am designing a tracking data base i am looking into the booking out side how would i be able to batch barcode scan a load of items on a booking out/purchase screen in then to be saved and can be printed out at goodsout? if anyone as a template would be fantastic

cheers hope anyone can help

 

[Uncle Gizmo]

>>>batch barcode scan a load of items<<<


With cheap bar code scanners you can only scan one barcode at the time and you would have to scan it directly into a spreadsheet cell or a text box on an access form.
I do know there are some very powerful barcode scanners out there, costing in the region of $2000, which have the facility for collecting batches of barcode scans. However whether you would be able to integrate one with access or not I am not sure.

 

[munkeyroot]

Hi Uncle Gizmo

Thank you for the informtion, yeah i've managed to find the scanners that no problem, its more of the programming access to allow me to scan single items and add them to a booking out spreadsheet or equivalent in access to then generate a printable report.

this is what i'm wanting to do

goods in
weighbridge ticket gets opened (via another app)
items get scanned and barcoded and added to access with a log of weighbridge ticket no.

goods out
weighbridge ticket gets opened (via another app)
items with barcodes get scanned into access booking out bit against the new weighbridge ticket number, then is saved/stored in access for a goods out/purchase report print out at weighbridge.

bit stuck ha ha

hope this helps bit more pal
thank you for your time.
matt