Access Library Inventory

[jlydon]

I have an Access database with 6,000 books entered. I have barcodes in
the books and want to do a year end inventory. I will scan the barcode
and would like that to show up as present in the database. Finally
those books not "present" would be known to be lost. Any help on how
to do this. Thanks.

 

[John Vinson]

I have an Access database with 6,000 books entered. I have barcodes in
the books and want to do a year end inventory. I will scan the barcode
and would like that to show up as present in the database. Finally
those books not "present" would be known to be lost. Any help on how
to do this. Thanks.

I'd suggest creating a table Inventory, with two fields: BookID (your
barcode field) and WhenInventoried, Date/Time field defaulting to
Now(). Base a Form on this table, displaying only the bookID; be sure
the form's Cycle property is All Records and that the textbox bound to
the BookID has its AutoTab property set to true.

This form should let you scan books as fast as you can move them under
the laser; it will fill a table with all the ID's that you scan.

You can then use an Unmatched Query wizard between this table and the
master books table to identify those that didn't make it back onto the
shelf.

John W. Vinson[MVP]

 

[jlydon]

John: Many thanks. Works well. John

I'd suggest creating a table Inventory, with two fields: BookID (your
barcode field) and WhenInventoried, Date/Time field defaulting to
Now(). Base a Form on this table, displaying only the bookID; be sure
the form's Cycle property is All Records and that the textbox bound to
the BookID has its AutoTab property set to true.

This form should let you scan books as fast as you can move them under
the laser; it will fill a table with all the ID's that you scan.

You can then use an Unmatched Query wizard between this table and the
master books table to identify those that didn't make it back onto the
shelf.

John W. Vinson[MVP]