[scholarscoll]

how to write save and edit button codes if i am saving in MS-Access

[PsychoCoder]

[rules][/rules]

[akhileshbc]

What technology are you using???? ADO or DAO????

[jaakko]

scholarscoll, on 16 Sep, 2008 - 01:00 PM, said:

how to write save and edit button codes if i am saving in MS-Access

Save button code:

if data1.recordset.updatable then data1.recordset.update

Edit button code

Data1.recordset.edit

[akhileshbc]

Quote

Save button code:

if data1.recordset.updatable then data1.recordset.update

Edit button code

Data1.recordset.edit

Its DAO !!!

[raziel_]

read the second post carefully

[Jovel Mark]

that's so simple ...

if you using ado, you can add and edit by this code
this is for add

 dim add as string
add = "Insert into table1 values('" & text1.text & "'......)"

this is for edit

 
dim edit as string
edit = "Update table1 set Name='" & text1.text & "'"

hope it can help

[macosxnerd101]

Please pay attention to the dates and avoid necroposting. Thank you!