Hi,
I am very new to VB and I am using Access 2010. I've copied the code from this forum on AuditTrail. I followed all the steps, imported the tblAudit and the two modules. However when I run it, i keep on getting 3251-Operation not supported for this type of object. Somehow it doesn't seem to like Oldvalue, I was able to display the ccnt.value but not the ccnt.Oldvalue. I will get the error even on just displaying ccnt.oldvalue.
It seems to work ok in older version of Access but just not in 2010.
I tried it on a single form as well as continous form in 2010, but both doesn't work either.
Appreicate if anyone can help, many thanks in advance.
I am very new to VB and I am using Access 2010. I've copied the code from this forum on AuditTrail. I followed all the steps, imported the tblAudit and the two modules. However when I run it, i keep on getting 3251-Operation not supported for this type of object. Somehow it doesn't seem to like Oldvalue, I was able to display the ccnt.value but not the ccnt.Oldvalue. I will get the error even on just displaying ccnt.oldvalue.
It seems to work ok in older version of Access but just not in 2010.
I tried it on a single form as well as continous form in 2010, but both doesn't work either.
Appreicate if anyone can help, many thanks in advance.