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

[rajdip82]

hi
how r u?
i have a question like when i use ms access with making database in a table and use a forms and in a forms i want to add command button like add, update, delete, exit
so give me reply
as soon as possible
thank u

[GaryMazzone]

So what is the question..... You can do all that no problem

[dee-u]

Hi rajdip82, welcome to the forums!

I have a link in my signature on adding records to Access database, have a look...

[sparbag]

hello

I do believe that you want to know how to add buttons onto your Access forms.

1. Open your form in design view.
2. Select a button from to control box.
3. Place the button onto your form.
4. Follow the instructions relating to what you want it to do.

Record Operations for Add, Delete, Update.

Kind regards

Steve

[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

[GaryMazzone]

You should not be opening a recordset just to add records. You issue an Insert SQL statement on a connection object command property

[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.