Time Tracking

[harix]

I am creating a database that tracks tech's time spent waiting for parts, waiting for customer approval, working, idle and not on the clock (lunch, personal, end of day). I set up a table and form for each tech (the form uses command buttons for each task to enter the start time and task id/name and a command button for each task to set the stop time and create a new record) so I can limit the tech to track only one task at a time.

I tried options groups etc. but everything seems too complicated when using these approaches. A combo box works but the techs want to just push buttons. I do not have a problem in figuring time values but am stumped as to how to code the buttons so they must stop the present task before starting another and how to prevent them from entering a stop time without a corresponding start time.

Any suggestions????

Thanks in advance for all the help! I am learning quite a bit from y'all.

Harry

 

[OutbackInvestments]

I dont know EXACTLY what you are getting at, but it sounded to me like you could use some "OnClick" coding to do what you want. I can only give you Pseudocode though, Im still working on figuring out VB-App myself. (Visual Basic for Applications (Access Basic))

Something like this?
Private Sub ButtonName_OnClick()
Stop All Timers
Record Time In Field
Init New Timer Control
Begin Timer
End Sub