I am new in the area and I try to write some lines but I need your help
I work with 2003 version
Now, I have made a db, the part are:
1 table with 5 columns id, barcodes, pieces, weight, colour
1 same but with no data 1 qry based on 1 tbl of choose and
1 frm with compo frame barcode and pieces, weight, colour
(The only variable is the pieces) winch I have connect the 4 columns with code
The line of compo come from SQL:* and barcode
Letâs say what I enter a barcode
When a write for 2 times the same bc I want to add the number of pieces this time to the previous entry
How I input the data?
In data sheet view with my barcode machine I import my bc automatic
All the line is preset by the tbl1 who include the data
I have set in options in move after enter the cursor goes to the next record
So I just push the button of my bc machine
Describe the barcode
The bc has one arrow in the end .If I click in the arrow appears the
Others columns, pieces weight and color
I connect all with a code from bor code control elements
The code I use is:
> > Private Sub BARCODE_AfterUpdate ()
> > Me. pieces = Me.BARCODE.Column (1)
> > Me. weight = Me.BARCODE.Column (2)
> > Me.colour = Me.BARCODE.Column (3)
> > End Sub
Whatâs happen now?
When I enter a same bc the line appears as the times I input the same bc
For different its wok normal
What I want now?
If I input the same bc for multiple times the number of
Pieces just add
Please can you help me?