same entry for second time

  • Thread starter Thread starter mark7
  • Start date Start date
M

mark7

Hello 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 of choose and
1 frm with composite barcode and pieces,weight,colour
(the only variable is the pieces) wich i have connect the 4 columns
with code

lets say what i write a barcode when a write for 2 time the same bc i
want to add the number of pieces this time to the previos entry
Please i want the code

pls help me friends
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
 
Hello 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 of choose and
1 frm with composite barcode and pieces,weight,colour
(the only variable is the pieces) wich i have connect the 4 columns
with code

lets say what i write a barcode when a write for 2 time the same bc i
want to add the number of pieces this time to the previos entry
Please i want the code

pls help me friends
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
Click to expand...

Are you using an Access-type edit screen? If so, just find the right
record and type in the quantity. If not, then you must be using VBA;
you will still have to have a way of finding the record and displaying
it on the screen. How is it that BARCODE has columns? Is it a
listbox? Are you using a listbox for data entry? Please explain...
 
Thank you very much for your answer
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 ijust push the button
describe the barcode
the bc has one arrow in the end .If i klick in the arrow apears the
others colomns ,pieces weight and colour
i connect all with a code from bor code control elements
the code i use is:
whats 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

thank you
 
Back
Top