creating a time clock

[Avalon-and-on]

Okay, this should be simple I know - however I am extremely new to this and banging my head up against the wall.

I have my table set up as an employee time clock. In the form, I am trying to force the time to automatically display in the "time in" field, when the employee enters his ID in the Id field. I am coming up short on the expression necessary to make this happen.

Then when they come back to the same form, the IN time stays the same as it was when entered and cursor automatically goes to the OUT time, which also displays automatically. Then total hours field fills in upon OUT time confirmation (enter).

Thank you in advance,
Jon

[Keith Hubert]

Re: creating a time clock

Hi Jon,

Not quite sure what you are trying to do, but I suggest you look at form events.

[Avalon-and-on]

Re: creating a time clock

okay, sorry. Here is a shot of my time clock. In the upper right hand field, the employee will enter their number and press enter. At that point, I want the date and time to appear in the "IN" field. Then they leave the form. When they return, it will be a blank form again and prompt for their number. When they enter their number, the previous "in" time pops up and the "out" time (current) as well as "total hours" and a running total of the week to date ("wtd hours") and "overtime" total will fill in their respective fields automatically. When they press done ( a button yet to be installed) all info will be saved. I hope this is not too confusing.

[jkletrovets]

Re: creating a time clock

Jon

You can most definitely do what you are looking to do. I have attached some screen shots of the Time Clock System I have developed for a couple of clients. I am in essence doing what you are looking to do but in a slightly different format. Perhaps this will give you some ideas.

When you are trying to capture the person "punching out" - you need to find the record involved. It seems from your example the user can only be punched on to one thing at a time so you would need to find the record for that employee id where the punch off time is blank. This will take you to the appropriate record. There you can do all the math you require - although you might need to use variety of functions to get you where you want to go since you want wtd and OT. For example if all of these punches are going into a timeclock table then you could use dbsum() if you have the proper indices set up and just total the appropriate field(s) or use tablesum() since you can pass a filter to it. DBSUM() is a bit quicker since it uses an index but in reality I have found tablesum() to be pretty snappy as well. For your WTD value you would create a calculated field and populate it with either the dbsum() and/or tablesum(). That really depends on your underlying database structure though.


Regards,

Jeff

[Avalon-and-on]

Re: creating a time clock

Thank you very much for putting the time and energy into this. Im going to go work on this now.