Last Updated Clock

  • Thread starter Thread starter FrunkaBlunka
  • Start date Start date
F

FrunkaBlunka

Hi Everybody,

How would I go about making a clock on a form that shows when a record
was last updated or added?

ie Last Updated on the Thursday 5th August 2006

Thanks.
 
I don't know about a clock... but here is some general info:

** Tracking date record was created or updated **

Add these 2 fields to all your tables and make them the last 2 fields.

DateCreated, date, DefaultValue = Now()
DateUpdated, date – set on the form BeforeUpdate event

the best way to use the DateCreated field is to set a default value of
=Now()
in the table design.

For DateUpdated, make sure it is on your form (I put it in the form
footer and LOCK it. Then, use the Form BeforeUpdate event to set the value

me. DateUpdated = now()


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
 
Yes!

Thanks Crystal it works now. Just one slight problem I have a couple of
subforms on my main form which is the only one that the update function
works on. I have a button on my form callded cmdUpdate button which is
just a general button that refreshes the form data. Instead of having
all the update fields in all my tables is it possible just to have some
sort of code to DateUpdate once pressed. Thanks again!

Blunka
 
you're welcome, Blunka ;) happy to help

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top