AnsweredAssumed Answered

Visual Basic 6 - To Edit/Update the Database (Access file)

Question asked by k_seng83 on Jan 2, 2008
Latest reply on Jan 2, 2008 by k_seng83
I'm developing a Tracking Program where to track the MRB Board flow in Agilent CTD.

I am facing the problem when I want to write the source code for edit/update my database.
Below is the source code that I wrote.

Dim rs As Recordset
Set rs = db.OpenRecordset("SELECT ID FROM Record WHERE ID = CInt(txt_ID.Text)")
If rs.EOF Then
  rs.AddNew
Else
  rs.Edit
End If
rs![Repairer] = txt_Repairer
rs![Action taken] = txt_Action
rs.Update

When I tried to run it, there is pop up the error message "Method or data member not found".

Is anyone have the idea to edit my code or any source code sample for me to refer to.
Thanks in advance.

Regards,
Keat Seng  

Outcomes