i have a textfield on the form, its associated with a field in the table. a barcode scanner will directly enter complete barcode into the form field. now i have to provide validation so that duplicate values are not stored.
my barcode is as follows 060010305001
( here 06 is supplier number, 001 is itemcode, 03 is current month, 05 is current year, 001 is item number)
on my form, i will be having a list of supplier number, and a date time picker to select the date.
i want facility such that if a duplicate barcode is entered, the system will not insert the data into the table, instead it will display warning .
which event should i use,,, before update or what for my barcode number textbox... and what will be the code...
if i want to compare a value with a selected item in the listbox , what i have to to
listbox1.itemselect(listbox1.selected) ------ is this correct..please provide me correct code.
also, tell me how to make sure that duplicate values are not entered into the databse at any cost.
my barcode is as follows 060010305001
( here 06 is supplier number, 001 is itemcode, 03 is current month, 05 is current year, 001 is item number)
on my form, i will be having a list of supplier number, and a date time picker to select the date.
i want facility such that if a duplicate barcode is entered, the system will not insert the data into the table, instead it will display warning .
which event should i use,,, before update or what for my barcode number textbox... and what will be the code...
if i want to compare a value with a selected item in the listbox , what i have to to
listbox1.itemselect(listbox1.selected) ------ is this correct..please provide me correct code.
also, tell me how to make sure that duplicate values are not entered into the databse at any cost.
