Saving data to database using array of textboxes

[MarQ]

good day, Assuming that i already have a module to connect to my database, i just want to ask how i can save data to an MS Access database from my VB6 using array of textboxes, i just think that by doing this my code will be shorter and hopefully make saving to the database faster ...all i want is to make my code in "saving, searching, deleteing" of data in the database shorter and faster and clean. no more long codes..(i have seen in a book just giving commands to array using Lbound and Ubound, but i dont know how to do it using it to the database ..thank you and more power..help is greatly appreciated..God bless am new to vb6 programming.

 

[ZOR]

Have you tried searches on this site? Also pay a visit to Planetsourcecode.com, you will find lots of example downloads. Regards

 

[MarQ]

Yes, sir I have tried..but with no luck..i tried using the keyword "array" but unfortunately, i wasnt able to find..hope you can help me..again thank you and more power..help will be greatly appreciated

 

[MarQ]

I still havent found a code on what i have been looking for..can anyone help..pls???

 

[ZOR]

You really need to start looking up ADO. Arrays won't help much as thats just a collection of controls or values. Apart from wanting to save data from arrays, do you know how to move data from VB into Access?. If you do then it's a question of looping the text array values into a recordset of the table you are sending the data to. Have a look at

http://www.planetsourcecode.com.

In the search put VB to Access. Scroll down the page and you will see downloadable examples showing VB to Access. Its a good start if you are starting from scratch. I might have got it wrong and you know more than your thread message suggests. Good luck.