Hi Robin,
add the following 2 fields to all your tables:
-dtmAdd, date/dime, DefaultValue=Now()
-dtmEdit, date/dime, DefaultValue=Now()
-dtmEdit, date/dime, DefaultValue=Now()
put dtmEdit on all your forms (I put it in the footer) and update dtmEdit with the BeforeUpdate event. Don't let users update tables directly.
Add Tracking Fields to tables -- @ 9 min 28 sec
http://www.youtube.com/watch?v=kmECCLqkQtY#t=9m28s
http://www.youtube.com/watch?v=kmECCLqkQtY#t=9m28s
Then you can use dtmEdit to find the latest records changed in every table. If you want to know specific the specific field also, then create a table to track changes and loop through controls to get OldValue and Value to see what changed (unless there are only specific values you are interested in).
Warm Regards,
Crystal
Remote Programming & Training -- connect to me, let's build it together
Through sharing, we will all get better
~ have an awesome day ~
Crystal
Remote Programming & Training -- connect to me, let's build it together
Through sharing, we will all get better
~ have an awesome day ~
On Friday, September 5, 2014 10:05 PM, "Robin Chapple robinski@westnet.com.au [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Thanks Duane,
Where do I find them? The file date would be acceptable for the project in hand.
Cheers,
Robin
At 6/09/2014 01:36 PM, you wrote:
The file date would never be a reliable indicator of the last date any records were updated. There are a number of methods for adding audit functionality to a table or tables that would be much more reliable.
Duane Hookom MVP
MS Access
----------------------------------------
> Subject: [MS_AccessPros] Last Updated field in a report
>
> I have a report to which I would like to add a date to indicate when
> the data was last updated. Is it possible to use the file date for
> this purpose so that a non skilled user can issue a report and the
> last update will show?
>
> The report already shows the date printed which is not necessarily the same..
>
> Many thanks,
>
> Robin Chapple
__._,_.___
Posted by: Crystal <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar