By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,400 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Track date of Updated records

P: n/a
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
Jan 17 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Jan 18 '06 #2

P: n/a
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.

Jan 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.