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.Connection
cnn.Open "Provider=microsoft.jet.oledb.4.0; data source=d:\Student.mdb"

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

[slapshock]

Dim cnn As ADODB.Connection
Dim rs As ADODB.recordset
cnn.Open "Provider=microsoft.jet.oledb.4.0; data source=d:\Student.mdb"
rs.open"select * from table",cnn,3,3

rs.addnew
rs.fields(1)=txtfield.text
rs.movenext

rs.close
cnn.close

soulfly

[suvarna]

Dim cnn As ADODB.Connection
Dim rs As ADODB.recordset
cnn.Open "Provider=microsoft.jet.oledb.4.0; data source=d:\Student.mdb"
rs.open"select * from table",cnn,3,3

rs.addnew
rs.fields(1)=txtfield.text
rs.movenext

rs.close
cnn.close

soulfly

thank you for the reply it worked...

[suvarna]

Dim cnn As ADODB.Connection
cnn.Open "Provider=microsoft.jet.oledb.4.0; data source=d:\Student.mdb"

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

thanks a lot for your help..