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.
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.