Tracking Changes
I searched prior discussions before posting this, so I apologize if it's a duplication. If it is just refer me to the prior article. Anyhow, I have a table with 45 fields, any of which could change. I'd like to keep an audit trail of changes to records for any of the previously mentioned fields. How would I set it up so I can bring awareness to which field changed and perhaps what the old value was and now the new value? I want my clients to be able to pull reports of any changes based on a particular record ID. Thanks, ------------------------------ Michael Sargent ------------------------------How to see when a report was created & who created it
I am trying to see if I can find out when a report was created, & what user created it. I know that information is found at the bottom of the page in the tables, but I can't figure it out for the reports. ------------------------------ Laura Diak ------------------------------
Is there a way to track who modified a specific field being changed?
Is there a way to track who modified a specific field being changed? I have a a check box called "Checked In". I would like to be able to see which user selected this option and when it was done so it could be referenced later if needed. There may be other changes in the form that could occur after the "check In' box was selected so i can not relay on the "last modified by" remarks on the bottom of the form to specifically provide accurate details as to who changed the specific checkbox once other fields are edited in the future.