Barcoding Stock Control Database

[johnbowser11]

Hi,

I am a beginner with making databases, so am looking for a bit of advice so I can know where to start.
What I'm trying to do is make a stock control database for our drugs dispensary as there are constantly drugs going in and out and they need to be able to keep track of where drugs have gone and what quantity levels they have.

I also have a 2D barcode scanner which scans and reads the drugs barcodes in the following format:


Product Code [Enter]
Product Descripition [Enter]
Batch Number [Enter]
Expiry Date [Enter]

So I would have thought the best thing would be to have a form with these fields in so the user could scan a barcode in filling in these fields. and that would then input the drugs into stock (Obviously there would be a quantity field too)

But where Im getting stuck is how could I then produce a form much like the one above with a search button. So the user could blip in the barcode filling in the relavant fields and then search for that product based on the products batch number?

Any Help would be MUCH appreciated.

Many Thanks

 

[johnbowser11]

once the search had found the relavant item, it would then need to be sold to a customer and the quanity sold to the customer would need to be deducted from the total quantity in stock, so the stock levels are correct

 

[johnbowser11]

Anyone? I really need help

 

[oldaf294]

inventory

I would be glad to try and help. I don’t really know if my method is the best or not but it works well.
I created another table Exactly like the original. Created a new form based on the new table. When I input new items in stock I enter the name in the first field. The second field is a UPC-A barcode. When I “exit” the barcode field an “on Exit” event is triggered that checks the original table for a duplicate barcode number. If found, a pop-up form opens and a msg box displays that "the item exists." I close the Msgbox, update the quantity, close the pop-up up, enter a new inventory name, go to the UPC number and go through the same process. When I am through entering the new inventory items, I press a command button and the new inventory is appended to the master table.
jim

 

[supmktg]

It's hard to tell from your initial question what your setup is. A barcode scanner is an easy and accurate means of data input. If it is a 'hardwired' (or wireless) input device, it is no different than a keyboard. Tab, Enter, etc. can be programmed into the scanner, and then as Jim suggested, code can run the same as if you had keyed the data into your form and then hit Tab, Enter, etc. on the keyboard.

If the scanner that you are using is a 'Batch' device, then you need to import the batches (most likely into their own table) and then process the imported data.

The tables should be the same with or without a barcode scanner, except for the additional 'Barcode' fields. The forms, queries, etc. should also be the same with or without a barcode scanner. There are many posts on this site regarding inventory and stock control that might be helpful in designing your database, don't let the fact that you are using a barcode scanner get in your way.

Sup