save and edit button codes

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

Page 1 of 1

8 Replies - 23969 Views - Last Post: 17 January 2013 - 12:22 AM Rate Topic: -----

#1 scholarscoll  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 1
  • Joined: 16-September 08

save and edit button codes

Post icon  Posted 16 September 2008 - 01:00 PM

how to write save and edit button codes if i am saving in MS-Access
Is This A Good Question/Topic? 1
  • +

Replies To: save and edit button codes

#2 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1639
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: save and edit button codes

Posted 16 September 2008 - 01:08 PM

[rules][/rules]
Was This Post Helpful? 0
  • +
  • -

#3 akhileshbc  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 9
  • View blog
  • Posts: 179
  • Joined: 27-September 08

Re: save and edit button codes

Posted 28 September 2008 - 12:13 AM

What technology are you using???? ADO or DAO????
Was This Post Helpful? 0
  • +
  • -

#4 jaakko  Icon User is offline

  • New D.I.C Head

Reputation: 7
  • View blog
  • Posts: 21
  • Joined: 26-September 08

Re: save and edit button codes

Posted 06 October 2008 - 03:20 PM

View Postscholarscoll, 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
Was This Post Helpful? 0
  • +
  • -

#5 akhileshbc  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 9
  • View blog
  • Posts: 179
  • Joined: 27-September 08

Re: save and edit button codes

Posted 06 October 2008 - 11:57 PM

Quote

Save button code:

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

Edit button code

Data1.recordset.edit

Its DAO !!!
Was This Post Helpful? 0
  • +
  • -

#6 Guest_leeb*


Reputation:

Re: save and edit button codes

Posted 31 March 2010 - 12:46 AM

View Postscholarscoll, on 16 September 2008 - 12:00 PM, said:

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



also i have a project with save and exit buttons whoul help me to write the code of these bottons
Was This Post Helpful? 0

#7 raziel_  Icon User is offline

  • Like a lollipop
  • member icon

Reputation: 464
  • View blog
  • Posts: 4,255
  • Joined: 25-March 09

Re: save and edit button codes

Posted 31 March 2010 - 01:10 AM

read the second post carefully
Was This Post Helpful? 0
  • +
  • -

#8 Jovel Mark  Icon User is offline

  • D.I.C Head

Reputation: -3
  • View blog
  • Posts: 81
  • Joined: 22-November 11

Re: save and edit button codes

Posted 17 January 2013 - 12:21 AM

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
Was This Post Helpful? 0
  • +
  • -

#9 macosxnerd101  Icon User is online

  • Self-Trained Economist
  • member icon




Reputation: 10488
  • View blog
  • Posts: 38,868
  • Joined: 27-December 08

Re: save and edit button codes

Posted 17 January 2013 - 12:22 AM

Please pay attention to the dates and avoid necroposting. Thank you!
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1