Results 1 to 4 of 4

Thread: Not able to update a table in VBA Access code

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2009
    Posts
    3

    Not able to update a table in VBA Access code

    Hi all,
    I am a beginner in Access VBA.
    I have an issue in updating a Table in the VBA code.

    I am reading a text file in this VBA code and extracting the message IDs from the file and write some comment for the message ID.
    I am trying to update the message ID and the comment to the Table "Result" using the below code. It is giving me Run time error - 3001. Invalid Argument.
    it stops at the line Rslt.Update.

    Code:
    Dim db As Database
    Dim Rslt As Recordset
    Set db = CurrentDb()
    Set Rslt = db.OpenRecordset("Result")
    Rslt.AddNew
    Rslt("Field1") = msg_id
    Rslt("Field2") = comment
    Rslt.Update
    Please some one help me to overcome this. It was working fine before. Now its giving error. Donno where I ve gone wrong.

    Thanks,
    Arasi
    Last edited by Arasi; Apr 15th, 2009 at 07:28 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width