Search results

If temp.State = adStateOpen Then temp.Close//here I get the error temp.Open "select * from Loanledger where staffno=" & dm.Fields("staffno") & " order by transdate desc", db, adOpenKeyset, adLockOptimistic, adCmdText If temp.RecordCount >= 1 Then ledger.AddNew ..... ledger.update I get the...

Hi All, I am new to VB programming. I am getting error while updating recodset. Database being used in the software is MS-Access. The complete error is "run-time error 3219. Operation not allowed in thos context". When we click on the OK button on error window then software will close...