Sending Information on my Form to A DB

[CODER]

Hello VB Guru's i have a minor problem and I would really appreciate some help.

I have some information on my form like name, date number, a whole paragraph and stuff like that in different text boxes now what I really want to do is for the user to hit a button and it send s all the information on the form to a database.

so how would I go abt doign this cause I have never done any database oriented programming in VB so this is my fiorst time so if u could send me some code that will get the info in a text box or list box and actually send it to teh database (access) that will be fine.

SO I wnat to know how do I actaully open the databse for connectivity??
Another qwuestion is how does it know where to store the info in the databse do I have to have created tables and all that so all I do is open my access file for i/o and then write out the info I need to write out??

Well PLS HELP!!!!!!!! ME OUT.......

THanks!!
CODER '99

[testermans]

Have you already created your database? If not go to the Visual Data Manager and create the database first with all of the fields that are on your form. Then go to the tool box and add a data control to your form. Set the Database Name property with the path to your database. Set the RecordSource property to the name of the datacontrol(you will want to name the data control to match the name of the table). Then, with each control on your form (text boxes, check boxes, whatever you may have used) you will need to set the datasource property to the name of the data control and the DataField property to the name of the field in the table. Good luck.