Form to Measure Worker Productivity

[kaveman]

Hello Friends,

I am currently working on creating a form that will measure a workers production rate in pieces per hour. Here are my goals for this form:

1. the worker would clock in to begin work. they would clock in using a button on the form that would then begin totaling the amount of time worked.

2. the form would query a table in my database to calculate the total pieces produced. this number would update automatically every 30 seconds.

3. there will then be a field on the form that takes the number of pieces produced and divides this by the total time worked to show the worker the current production rate in pieces per hour

I've looked all over to see if there is already a template created that would work for me and have had no luck. Does anyone have any advice on how to go about creating this form? I am very new to this type of a project so any help would be very much appreciated.

 

[kaveman]

I have come up with something but still need a little more help. I found a stopwatch template on the Microsoft website. I was able to use this to get my running clock and from there the rest was pretty simple. My trouble now is I would like to have two stopwatches on this form. I know it is basically the same code from the original stopwatch but I can't seem to get it right to the point where both stopwatches will run at the same time operating totally independent of one another. I have attached what I have so far...can anyone help?