date stamps for multiple forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zsl_3 - 18 Sep 2003 14:47 GMT

Hi,

Just wana ask if anyone knows wat to do in order for a date stamp to
work in multiple forms?

I have a form in which there are several subforms. I wanted to have a
date stamp to be included to check if the form and subforms have been
updated, if yes then show the date.

Thx!

Reply to this Message

Larry Linson - 20 Sep 2003 02:15 GMT

> ... wat to do in order for a date
> stamp to work in multiple forms?

If you mean the data shown in the Form, then it is relatively easy to add a
DateUpdated Field to the Record, and set it in the BeforeUpdate event of a
Form, if you limit updates to Forms, as you most likely should in a
"developed application". Giving users access to datasheet view can be
problematical (and you can't use this approach to set a timestamp).

If you mean when the design of the Form was changed, then a label that you
manually update when you modify the Form would be appropriate. Perhaps you
could automate this, but I don't recall anyone mentioning that they had done
so.

Larry Linson
Microsoft Access MVP

Reply to this Message