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.Updtae.
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
Thanks,
Arasi
|