Automatic Updates

[katz3yez]

Current Date Tracking (automatic update)

Hi,

I would like to automatically track any updates that goes on in my database. I would like to track the date whenever any changes, updates happens on a record. I tried using after update =NOW() on the date field but I can't seem to make it work. Can anybody help me? Thank you.

 

[boblarson]

Two things -
1. You have to use the BeforeUpdate to add it otherwise you would run into a perpetual loop. You would update the field after it's been updated and then it will have been updated again after updating it's date so it would update again, etc.

2. Try the search function on here and plug in Audit Trail as there are several posts and examples posted.

 

[katz3yez]

Date Tracking

Hi, I tried the search option you mentioned but I couldn't find anything similar to it. Do you have any examples or does anybody have something? Thank you.

 

[boblarson]

Well, I plugged in the same words and it gave me, in the 5th post down -
http://www.access-programmers.co.uk/forums/showthread.php?t=44231&highlight=audit+trail
And in it GHudson posted a sample (see the 6th post down in that post)

 

[katz3yez]

Hi Again...

Thank you. I'm getting there. I tried the sample but it's giving me this error 3251: Operation is not supported for this type of object. It works but it gives me this error message whenever I go to another record. I also have pull downs. Do you think is the problem? Thank you.