Countdown Database

[marksa]

I was asked to come up with a "40 Hour" timer for some folks that work from a home office. After reviewing some samples it seems the best way to do this was to use a timer event and count down 14400 seconds (40 hrs x 60 min x 60 sec). Also wanted to display the time left in "hours" and "minutes"

Created a small db to do this and was hoping someone could check it over - the hours/minutes display was a little confusing.....

Thanks in advance.

 

[llkhoutx]

The Access form Timer Interval is milli-seconds, not mere seconds.

 

[dt01pqt]

I was asked to come up with a "40 Hour" timer for some folks that work from a home office. After reviewing some samples it seems the best way to do this was to use a timer event and count down 14400

Not nessarily. Can you explain in more detail what the timer is for.

 

[marksa]

Purpose

The purpose of the timer is to make sure they put in a 40 hour work week. All of these people work from home on flex schedules that include evenings and weekends.

 

[dt01pqt]

The purpose of the timer is to make sure they put in a 40 hour work week. All of these people work from home on flex schedules that include evenings and weekends.

I have Acc97 on this computer so I can't see your sample. But I presume they have to have the form open all the time and you store times for adding up. I don't think this is realistic. Having a timer on all day is a waste of processing time, and if the user is having technical problems they are screwed. The computer has it's own clock you can log the sessions or even get them to log-in remotely so the time is absolute. I think it is important you get this right; people’s integrity is at stake.