How to time a record?

[hoja]

Hi, I created a DB and I want to add a feature and I'm not sure how to do it. Basically, I want the DB to warn me that a period of time has past since the record was inserted into the DB. So, when I insert a record, I want the DB 2 days from that time to warn me that the record has not been modified or touch in 2 days....is this posible?? any help would be great, thank you

Rod

 

[PHV]

Having a TimeStamp field in the table you may create a query with criteria on this field.
The TimeStamp should be set by code in the BeforeUpdate event procedure of the form populating the table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hkaing79]

Along similar lines, I have a table bound to a form and would like to time the time it takes to complete the form. I'm assuming I would use BeforeUpdate to log the finished time, but what about the start time?

 

[PHV]

I would test Me.NewRecord in the Current event procedure of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hkaing79]

Oooh nice. Thanks.