Incremental Mechanism need
-
hello all, am creating one small project using vb and msaccess. my problem is i have a field name barcodeno in it i want incremental values. for example i have a partno in that Part no it self contain 1200 different Barcodeno i cant even enter one by one so am in need of some auto incremental mechanism. start value and end value only recevied in different text boxes. Annnnnnnnnny Ideas Please Help me....... Thanks in advance
-
hello all, am creating one small project using vb and msaccess. my problem is i have a field name barcodeno in it i want incremental values. for example i have a partno in that Part no it self contain 1200 different Barcodeno i cant even enter one by one so am in need of some auto incremental mechanism. start value and end value only recevied in different text boxes. Annnnnnnnnny Ideas Please Help me....... Thanks in advance
There's not enough information on the problem to tell you anything. ALl we have is you have field that holds 1200 BarCodeNo's and you need to increment the BarCodeNo value. Increment how? Are you looking to get the last BarCodeNo in the database and increment it? Are you looking to autogenerate all the BarCodeNo's between two values (entered in TextBox's) and store them in the database? ??????
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
There's not enough information on the problem to tell you anything. ALl we have is you have field that holds 1200 BarCodeNo's and you need to increment the BarCodeNo value. Increment how? Are you looking to get the last BarCodeNo in the database and increment it? Are you looking to autogenerate all the BarCodeNo's between two values (entered in TextBox's) and store them in the database? ??????
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007Hello Mr.Dave, Thanks For Your reply. s am looking autogenerate all the barcode no's between two values and store them in the database. Please help me is it possible? and further how can we insert Bulk data's in the database (ie More than 300 rows at a time by cliclking a Button like "save"). am a begginer Please help me.
-
Hello Mr.Dave, Thanks For Your reply. s am looking autogenerate all the barcode no's between two values and store them in the database. Please help me is it possible? and further how can we insert Bulk data's in the database (ie More than 300 rows at a time by cliclking a Button like "save"). am a begginer Please help me.
Creating the records for the barcodes isn't that hard. You already know how to add records to a database in your code. All you have to do is enclose that in a loop and start inserting new records, one at a time. If all you're doing is creating records that have nothing but a barcode, why are you even creating them? Normally, you wouldn't do this until you actually assigned the barcode to an item and entered the details of the item into the database.
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
Creating the records for the barcodes isn't that hard. You already know how to add records to a database in your code. All you have to do is enclose that in a loop and start inserting new records, one at a time. If all you're doing is creating records that have nothing but a barcode, why are you even creating them? Normally, you wouldn't do this until you actually assigned the barcode to an item and entered the details of the item into the database.
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007hello Am a beginer only i dont know how to increment a value in a datagrid and also the bulk insert in MSAccess. at a time we can only enter one row in a database but in my project for exammple they have one product, that product belonging from one company but that particular product contain 100 different barcode no in that case only i need increment mechanism. am creating text boxes for enter product and company name below that a datagrid for enter all barcode for that product whenever i submit all the barcode and then press a add button 100 rows will automatically enter into a database. is it possible or not? if possible how? Please give me any example code
-
hello Am a beginer only i dont know how to increment a value in a datagrid and also the bulk insert in MSAccess. at a time we can only enter one row in a database but in my project for exammple they have one product, that product belonging from one company but that particular product contain 100 different barcode no in that case only i need increment mechanism. am creating text boxes for enter product and company name below that a datagrid for enter all barcode for that product whenever i submit all the barcode and then press a add button 100 rows will automatically enter into a database. is it possible or not? if possible how? Please give me any example code
rrrriiizz wrote:
Am a beginer only
Nothing like jumping into the deep end of the pool without knowing how to swim! You don't know what you're doing. This is what is making this description so hard. I'll simplify this as much as I can. When you create the barcode records, you don't have to put the barcodes in a DataGrid. Actually, you don't ever insert them into a DataGrid. All you do is create the barcodes using an SQL INSERT (OleDbCommand object) directly into your table, inside a for/next loop. When those records are completed, you requery the database using a SELECT statement and a OleDataAdapter object, to retrieve the records between the beginning barcode and ending barcode numbers, filling a DataTable with the results. You then bind the DataGrid to the DataTable. Your user can then start entering the information about each barcode into the table. When they're done, you write the information back to the database using the same OleDbDataAdapter you created to fill this table.
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007