Microsoft Access? add subtract barcodes?
Microsoft Access? add subtract barcodes?
at work we are trying to keep track of our stock in inventory. we will be using a barcode scanner and have a barcode for each item (all vga cables one barcode). We get items in and out a lot so we’d like to just scan items + to add to qty list and scan out to – qty list. how would we do this??
Best answer:
A program that updates the record for that number (barcode readers output text). You could write it in VBA in Access or you could write it in another language and link to the mdb file.
Tags: access, barcodes, Microsoft, subtract
Under Forum
2 Comments for Microsoft Access? add subtract barcodes?
1. Nicholas J | May 17th, 2007 at 12:56 pm
You would begin by asking questions in the correct section.
Why you are asking a very specific MS Access user question in the programming area is beyond me.
2. Andrew L | May 17th, 2007 at 12:58 pm
I suggest you have three tables – stock description, stock in, stock out. Each table has a barcode field. The item description table has the barcode field as a unique identifier.
The stock in and out tables are used to rapidly scan items in and out. Every scan creates a new record in the relevant table. I would suggest that each table also has a date field which defaults to the current date. This allows you to query transactions from specific days or over specific periods. It’s important to note, these tables don’t show stock levels, just literally transactions.
To show stock levels you will create queries, linking the stock in and out tables to the stock description. Each query totals the transactions. If accurate, you should be able to subtract one from the other to get current stock levels. You will be able to filter it, to get stock levels for particular products or types of product.
Leave a Comment for Microsoft Access? add subtract barcodes?
You must be logged in to post a comment.
Trackback this post | Subscribe to the comments via RSS Feed