Time clock form

[migrif]

Has anyone on the list created or used a time clock form i.e. Punch in/Punch out like a time card? I am interested in how it worked, and compare against what I am doing.
Thanks in advance.
Mike G

 

[cooh23]

I created a time tracker which also requires them to clock in and clock out.

Post what you have done so far and maybe when can give you some ideas.

What exactly are you trying to accomplish with this database you are making?

 

[migrif]

Within our warehouses, delivery notes are created, and used to pick materials to ship. A time stamp is used to clock when the pick list went to the floor, and then when it was checked in (complete). I have created a simple 6 field form for data entry. I was using a clock function I found on microsft.com http://office.microsoft.com/en-us/access/HP011210611033.aspx?pid=CH063650361033
which worked, kind of. I could add the functionality in the article, which worked for the "Check Out" time, but when I tried to duplicate the code for "Check In" I had issues with the "On Current" event, and how to get both to work. Right now, I have a simple Short date input field I am using, but I would really like the abiltiy to you this (or similar) clock functionality. I hope all of this makes sense.
Thanks in advance.
Mike G

 

[cooh23]

Here's mine View attachment Time_Logger.zip

Change the tblfunctions to whatever functions you have.

you could add Clock in and Clock out and other functions you may have.

username is automatically detected so whoever is logged in is automatically selected.

let me know if you have any questions. i hope this helps.

 

[migrif]

This looks great, although I have to look at it in design mode, as I think it's read only, and isn't displaying any fields in form view. having said that, you have given me some great ideas, or at least I can see how you did several pieces of functionality I was considering.
Thanks a bunch!
MG

 

[cooh23]

This looks great, although I have to look at it in design mode, as I think it's read only, and isn't displaying any fields in form view. having said that, you have given me some great ideas, or at least I can see how you did several pieces of functionality I was considering.
Thanks a bunch!
MG

the fields will be displayed in the subform once you enter your data.. enter your data and click add activity

You're welcome. Start typing in your entry in the form.. if you username doesn't appear in the username section.
Go to design mode and remove the default value of the username and change Locked to No.

to add a user name, go to tblemployees.

i also have reports designed so you can look at that.

hope that helps.

 

[migrif]

Still no go unfortunately....also, with the Read Only, there is no way to add my ID to the list.

 

[cooh23]

Still no go unfortunately....also, with the Read Only, there is no way to add my ID to the list.

Try extracting the file to your local drive. you're probably opening it from the zip file.

The file is a .mdb file, you should be able to do anything with that file.

 

[migrif]

You're exactly right, I wasn't thinking, and just opened it directly from the ZIP. In your time calculation, it doesn't appear that you are saving it to a table is that correct?

 

[cooh23]

You're exactly right, I wasn't thinking, and just opened it directly from the ZIP. In your time calculation, it doesn't appear that you are saving it to a table is that correct?

That's correct. Calculation should be done on the fly. There's really not a need in the table. My calculation was done through an unbound textbox.

 

[migrif]

So, if I am reading this correctly, have the time elapsed calculated in a queery, where from I can report on it?

 

[cooh23]

So, if I am reading this correctly, have the time elapsed calculated in a queery, where from I can report on it?

I am not sure what you are asking..
In the query, i have a TotalTime that calculates the Endtime - Starttime. I use this in the Report.

 

[migrif]

That's what I was asking, so you nailed it! Thanks