using ms acces with use in forms in add, delete, exit, update data record

[Hack]

Moved to Office Development

So what is the question

What is the answer to Gary's question?

[bharanidharanit]

Hello,
You can able to add,edit,update and delete records using ADODB. Project->Components->Microsoft ADO Data Control 6.0 (OLEDB)
Add that to the form

Now put 4 buttons as Add,Delete,Edit,Update

coding:
dim db as new ADODB.Connection
dim rs as new ADODB.recordset

private sub form_load()
db.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\Final Full\EXE\horse.mdb;Persist Security Info=False"

Bold contents must be your database path
rs.open "Select * from details",db,3,2

This bold contents must be your recorset name where to add the datas.

end sub

Private sub add_click()
rs.addnew
rs.fields(0) = text1.text
rs.fields(1) = text2.text
etc
rs.update
msgbox "Data Added"
End sub

If my post was helpful pls rate me

[dee-u]

Hello,
You can able to add,edit,update and delete records using ADODB. Project->Components->Microsoft ADO Data Control 6.0 (OLEDB)
Add that to the form

Now put 4 buttons as Add,Delete,Edit,Update

coding:
dim db as new ADODB.Connection
dim rs as new ADODB.recordset

private sub form_load()
db.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\Final Full\EXE\horse.mdb;Persist Security Info=False"

Bold contents must be your database path
rs.open "Select * from details",db,3,2

This bold contents must be your recorset name where to add the datas.

end sub

Private sub add_click()
rs.addnew
rs.fields(0) = text1.text
rs.fields(1) = text2.text
etc
rs.update
msgbox "Data Added"
End sub

If my post was helpful pls rate me

Using data bound controls for DML are frowned upon since they are considered evil.