- Local time
- Today, 11:24
- Joined
- Sep 12, 2006
- Messages
- 15,679
rather than user timers, you could just have a "refresh" button on the dashboard to recalculate, at the discretion of the user. It's only ever a snapshot anyway.
As stated in post 7:
Save a record when starting activity. When activity is changed, 'close out' open record then create a new record.
The 'current' activity is record where 'closed' field Is Null.
Calculate elapsed time with DateDiff() function using the logged in start date/time and Now().
Have a form bound to log table. RecordSource filtered to retrieve only records WHERE closed Is Null. Elapsed time calculation in query or textbox.
As stated in post 7:
Save a record when starting activity. When activity is changed, 'close out' open record then create a new record.
The 'current' activity is record where 'closed' field Is Null.
Calculate elapsed time with DateDiff() function using the logged in start date/time and Now().
Have a form bound to log table. RecordSource filtered to retrieve only records WHERE closed Is Null. Elapsed time calculation in query or textbox.
The interval unit must be within quote marks.
DateDiff("s", Me.Starttime, Now())
IT works now great! How do I make it look like it is counting every second?
You will hate yourself for doing this, but make the form have a timer equal to 1 second (1000 msec, since the timer unit is msec). High-frequency timers can make a system really sluggish. Do yourself a favor. Estimate how long it takes for a person to actually select a new task. Make your timer no more often than that interval, because don't forget you need to requery the user/task/time table once per timer tick. The more you drag across the network, the more it will resemble a "notwork."
If you do stuff that frequently, your IT department (if you have one) will hate you forever, worse than Gollum hated Bilbo Baggins.
Hi. Congratulations! Good luck with your project.Thank you everyone for helping me out on this, I was busy building the stuff for a while and got it figured out and it is up and running. I really appreciate it!