Track date of Updated records

[jerry.ranch]

Say I have a form.

On this form I want to reports back the last date data in any table
was modified (say in a subform, or other object??)

This way the user can see when the last update of information
occurred.

I was thinking I could run a qry that looks at MSysObjects, pull the
rows specifically of the tables I want to check, and take the largest
value in DateUpdate field, and report it out on a subform.

Could I use the Timer feature of the form to run the query, say every
hour then?

Thanks
Jerry

[Jamey]

I've looked at something like that before, but MSysObjects changes
periodically. For example, in A2K DateUpdate doesn't change at all and
is merely set to DateCreated.

You could add a field to track the value for you and set it to track
UserName and Time via the Now function. I'd stay away from DateUpdate
just because MSysObjects isn't consistent from version to version.

[Jerome Ranch]

Everyone in the company uses the same Access version.
But to build it so that it might break when we upgrade is not the
proper way to build an app.
I will try your suggestion.
Jerry

On 17 Jan 2006 16:41:42 -0800, "Jamey" <ca*********@yahoo.com> wrote:

I've looked at something like that before, but MSysObjects changes
periodically. For example, in A2K DateUpdate doesn't change at all and
is merely set to DateCreated.

You could add a field to track the value for you and set it to track
UserName and Time via the Now function. I'd stay away from DateUpdate
just because MSysObjects isn't consistent from version to version.