G
gobarr
I am not educated well in SQL, but if it is the only solution to thi
problem please show me anyway. Here is what I'm trying to do.
I have Access 97. I have a scanner that scans barcodes from products a
we receive them into our warehouse. Most of our products are rented s
they are continuously coming back to us, so we need a way to trac
them. Well in order for our CSR's to locate and identify our product
we have prefixes that need to be concatenated to these raw seria
numbers. E.I. WC (wheelchair) is concatenated to 38563892 (seria
number) to get WC38563892. We do this because we print out our ow
serial numbers and place them on all the products so that we can trac
them and have much more inventory control. So instead of a barcode tha
just has numbers 38563892 we have a barcode that has WC38563892 and i
can be scanned and easily recognized in our database so that we kno
that this particular item is back in our warehouse to be rented again
The difficulty is when we buy new items we have to add the correc
prefix to the serial number and we do this by typing it all in (ver
slow and prone to mistakes).
Well I developed a form that you can choose the corosponding prefi
from a list box and then scan the new products serial number next. The
I made a calculated field that concatenates these two to make th
correct serial number that we will be printing out to be placed on th
item for tracking. All I want to do is store that calculated fiel
value into a table so that we can print from this table the correc
labels, which may be hundreds, to be placed on the products. Then th
CSR's will be able to locate and see the status on these newly bough
items. We buy and receive lots of new items all the time, and thi
would be a huge time saver. Please help!
The follwing answer was given to me, but I am unable to get it to work
When I change the event procedure for any of the boxes on the form i
for some reason edits the event procedure for all of text boxes on th
form. I don't know how to change each of them individually. I need t
get more detailed intruction unfortunately.
On the form where you add new items, use 3 controls:
1. A (hidden?) text box bound to the primary key field.
2. An unbound combo where the user selects the prefix code (such a
WC).
3. An unbound text box where the barcode is read in.
Assuming these are called MyID, Prefix, and Serial respectively, us
the
AfterUpdate event procedure of Prefix and Serial to assign the value t
the
key field:
Private Sub txtPrefix_AfterUpdate()
If Not (IsNull(Me.Prefix) Or IsNull(Me.Serial) Then
Me.MyID = Me.Prefix & Me.Serial
End If
End Sub
Private Sub txtSerial_AfterUpdate()
Call txtPrefix_AfterUpdate
End Sub
Also, use the Current and Undo events of the form to clear the tex
boxes:
Private Sub Form_Current()
Me.Prefix = Null
Me.Serial = Null
End Sub
Is there a way to do this with the visual interface?
problem please show me anyway. Here is what I'm trying to do.
I have Access 97. I have a scanner that scans barcodes from products a
we receive them into our warehouse. Most of our products are rented s
they are continuously coming back to us, so we need a way to trac
them. Well in order for our CSR's to locate and identify our product
we have prefixes that need to be concatenated to these raw seria
numbers. E.I. WC (wheelchair) is concatenated to 38563892 (seria
number) to get WC38563892. We do this because we print out our ow
serial numbers and place them on all the products so that we can trac
them and have much more inventory control. So instead of a barcode tha
just has numbers 38563892 we have a barcode that has WC38563892 and i
can be scanned and easily recognized in our database so that we kno
that this particular item is back in our warehouse to be rented again
The difficulty is when we buy new items we have to add the correc
prefix to the serial number and we do this by typing it all in (ver
slow and prone to mistakes).
Well I developed a form that you can choose the corosponding prefi
from a list box and then scan the new products serial number next. The
I made a calculated field that concatenates these two to make th
correct serial number that we will be printing out to be placed on th
item for tracking. All I want to do is store that calculated fiel
value into a table so that we can print from this table the correc
labels, which may be hundreds, to be placed on the products. Then th
CSR's will be able to locate and see the status on these newly bough
items. We buy and receive lots of new items all the time, and thi
would be a huge time saver. Please help!
The follwing answer was given to me, but I am unable to get it to work
When I change the event procedure for any of the boxes on the form i
for some reason edits the event procedure for all of text boxes on th
form. I don't know how to change each of them individually. I need t
get more detailed intruction unfortunately.
On the form where you add new items, use 3 controls:
1. A (hidden?) text box bound to the primary key field.
2. An unbound combo where the user selects the prefix code (such a
WC).
3. An unbound text box where the barcode is read in.
Assuming these are called MyID, Prefix, and Serial respectively, us
the
AfterUpdate event procedure of Prefix and Serial to assign the value t
the
key field:
Private Sub txtPrefix_AfterUpdate()
If Not (IsNull(Me.Prefix) Or IsNull(Me.Serial) Then
Me.MyID = Me.Prefix & Me.Serial
End If
End Sub
Private Sub txtSerial_AfterUpdate()
Call txtPrefix_AfterUpdate
End Sub
Also, use the Current and Undo events of the form to clear the tex
boxes:
Private Sub Form_Current()
Me.Prefix = Null
Me.Serial = Null
End Sub
Is there a way to do this with the visual interface?