Automatically Zero a field

G

Guest

Need: To be able to scan serial numbers into a form and as they are scanned
the part details come up from inventory main table and then it 0s itself out,
and then the order is stored in a seperate database or the row is tagged so
that a report can be pulled up to show sales. I have no problem scanning the
data in.
Our scanner connects to Access automatically. It will scan the info
into the form without any problem. I just need to be able to query for the
data once the info is in the field. Either scanned in or manually entered. So
the data will be input no worries there.

What I need is a query or code that will search the Inventory main and
return the complete record based on serial number and put it in a table that
can be manipulated and will automatically update the field "Quantity" in the
inventory main table, and update a new Table "Sold Items" with the qty, desc,
Part Number, Model Number and Machine Number. This way we will have a record
of what has sold. But as I said the scanner is not the problem just the
manipulation of the Data. All fields are text fields.
 
R

Rick Gittins

EMail me and I can give you a hand with this. I would need to see the table
you wanted to work with and the form/table that needs to be populated.

Rick
 
G

Guest

I sent the database did you receive?
--
apps


Rick Gittins said:
EMail me and I can give you a hand with this. I would need to see the table
you wanted to work with and the form/table that needs to be populated.

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top