RE: Inventory Help

Right now I have two main tables.

One table that has the actual product.

And the other table is for all the different items with a structure of:
Item #
Product ID (relationship to the first table)
Current Location
Transfer Date

When the item comes into the building the item has a upc barcode on it and
then the staff puts on a second bar code for it unique item number.

So the staff scans in the second bar code to give it a unique item number
then scan in the upc number to let the database know what the item is.

I have it set up for the initial scan to tell it that the item is in the
storeroom room and it recive date is the current date.

So my main problem is to set up a form that when I scan in the itemid that
it will change it to a new location automaticaly.

Currently I have it set up with a search query in a form so when the item is
scanned it will pull it up and then i have to manualy change the current
location. Close it and reopen the form for the next bottle.

What I am hopeing to do if possible is to open a form call for example
transfer to storeroom #1 And scan the item number and then it will know that
item #100 is know it current location storeroom #1 and it was done on current
date. After the item barcode scan being able to scan the next item.

Thank You In Advance



"Nicholas Scarpinato" wrote:

I'm pretty sure I know what you're trying to do, but I need a better
description of the exact physical process before I can give you my best
answer. For now, I'll answer as best I can and we'll fill in the blanks as we
go.

Comments inline:

"Lost" wrote:

I have created a database for inventory for my work.

I have set up a table with product information and each product has
thousands of items. And each item has it own barcode on it.

I have set up a way for the database to know with a scan of a a bar code
what the item is and what number it is.

This is the easy part. Most barcode scanners read the barcode and translate
it to text much like if you were typing it in manually, so as long as you
have one of these scanners, just plug it in and you're good to go. As far as
using that information to search your database, you need a simple query that
uses that form control as it's criteria. But I'll get to that later on once I
know more about what you're trying to do.

What i need to do is figure out a way for the item to be given a location
and be able to change that location fast because hundreds of items move
thorught differents areas at my work everyday.

I'm assuming you have various checkpoints with a PC and a scanner at those
locations?

What I want to is to be able to scan the item and tell it is going to be
there now.

So you want an item that has reached a specific area, say "STOCK", to be
able to be scanned in and added to that location... and then later when that
item moves, you want to be able to scan it and change it again? I'm doing
much the same process right now for the returns department where I work, if
that's the case. Let me know more about what your process is, phsyically, and
I'll give you as much help as I can.
.

Relevant Pages

  • RE: Inventory Help
    ... ItemID = Me!'Get ItemID from barcode scan ... storeroom room and it recive date is the current date. ... I have set up a way for the database to know with a scan of a a bar code ... have one of these scanners, just plug it in and you're good to go. ...
    (microsoft.public.access.gettingstarted)
  • Re: orchid database?
    ... applicable information is databased for each accession, ... The mother flasks have a barcode with the M-number, the accession number, ... on special labels using thermal transfer ribbon. ... information in the database, ...
    (rec.gardens.orchids)
  • Re: update query
    ... structure of the database. ... I made a subform, using the tools on the left side, to make a subform ... pointing to the Transaction data base, bookbarcode, studentID, date- ... barcode - primary key ...
    (microsoft.public.access.queries)
  • Re: Suggestions for PocketPC SDK for 1D/2D Barcode Scanning via video/picture camera instead of dedi
    ... have seen lately have little applications that use the built-in Camera ... 2D barcode, which makes a chime sound then passes a user to a web site ... Any bar code scanner for a Windows CE/Pocket PC device ... I don't know of any add-on 2D scanners. ...
    (microsoft.public.pocketpc.developer)
  • BarcodeDB.com - a Barcode Database
    ... I am looking to set up a new 'public' database for barcodes. ... couple of barcode databases out there, ... UPC Database is old fashioned and over run ... When people upload or edit a product, ...
    (php.general)