how to add items in access database using vb forms

[suvarna]

hi

i am quite new with access n i don know how to add new items in the database from vb form at runtime

[Anatha Man]

hi

i am quite new with access n i don know how to add new items in the database from vb form at runtime

Dim cnn As ADODB.Connectio n
cnn.Open "Provider=micro soft.jet.oledb. 4.0; data source=d:\Stude nt.mdb"

cnn.Execute "insert into tblStudent(ID,n ame,sex,Address ) values('" & txtID & "','" & txtname & "','" & txtsex & "','" & txtaddress & "')"

[slapshock]

Dim cnn As ADODB.Connectio n
Dim rs As ADODB.recordset
cnn.Open "Provider=micro soft.jet.oledb. 4.0; data source=d:\Stude nt.mdb"
rs.open"select * from table",cnn,3,3

rs.addnew
rs.fields(1)=tx tfield.text
rs.movenext

rs.close
cnn.close

soulfly

[suvarna]

Dim cnn As ADODB.Connectio n
Dim rs As ADODB.recordset
cnn.Open "Provider=micro soft.jet.oledb. 4.0; data source=d:\Stude nt.mdb"
rs.open"select * from table",cnn,3,3

rs.addnew
rs.fields(1)=tx tfield.text
rs.movenext

rs.close
cnn.close

soulfly

thank you for the reply it worked...

[suvarna]

Dim cnn As ADODB.Connectio n
cnn.Open "Provider=micro soft.jet.oledb. 4.0; data source=d:\Stude nt.mdb"

cnn.Execute "insert into tblStudent(ID,n ame,sex,Address ) values('" & txtID & "','" & txtname & "','" & txtsex & "','" & txtaddress & "')"

thanks a lot for your help..