default value and dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ceadsearc - 01 Jul 2005 19:05 GMT

I know how to make one of the fields in a record be the entry date -- no
problem. What I also need is a "modified date" field where if any information
is changed in the record the date of the changes is automatically entered.

Can this be done and can anyone out there tell me how to do?

Many thanks,
Kelley in Baltimore

Reply to this Message

KARL DEWEY - 01 Jul 2005 20:41 GMT

You can build an event for On Close of your form to SetValue of the field to
Date() or Now().

That does not give you much information! You could have a history table
that records User, DateTime, & key field of the record changed.

> I know how to make one of the fields in a record be the entry date -- no
> problem. What I also need is a "modified date" field where if any information
[quoted text clipped - 4 lines]
> Many thanks,
> Kelley in Baltimore

Reply to this Message

Tim Ferguson - 02 Jul 2005 21:40 GMT

"=?Utf-8?B?S0FSTCBERVdFWQ==?=" <KARLDEWEY@discussions.microsoft.com> wrote
in news:5F5A76AF-CAE5-4D11-A2F8-4AE7DBD53BCE@microsoft.com:

> You can build an event for On Close of your form

The BeforeUpdate event is probably a better choice...

Tim F

Reply to this Message

ceadsearc - 05 Jul 2005 16:09 GMT

Karl,

I will try the history table. I have never done one, but I am hoping that I
can find online some instructions. If you know of any site, please point me
in the right direction. I am a little out of my expertise, but am a quick
learner.

Kelley

> You can build an event for On Close of your form to SetValue of the field to
> Date() or Now().
[quoted text clipped - 10 lines]
> > Many thanks,
> > Kelley in Baltimore

Reply to this Message