I want to add a field called dateMofied to my table, and set it as a date/time field. What I want to do is, have it capture the date/time of when the field "Book Title" is actually modified. How can I do this with my table?
I want to add a field called dateMofied to my table, and set it as a date/time field. What I want to do is, have it capture the date/time of when the field "Book Title" is actually modified. How can I do this with my table?
In a table, probably can't. In a form you'd use the after update event of the control containing "Book Title" and set the date field to Now().
I should have clarified that if you use a back end like SQL Server you could use a trigger, or later Access versions have data macros, which are similar (I think 2010 was the first version with data macros, but don't quote me on that).
How would I use a trigger? This is a linked SQL Server tale I want to do this action to.
As far as I know it has to be set up on the server. Do you have access to it, or is there a DBA?