Time Clock / Punch Clock App
Has anyone created a time clock Access application?
I'm referring to a app that will allow the user to sign-in at the beginning of the day then sign-out for lunch, sign back in then sign out at close of business. Then be able to total the number of hours at work.
I've searched the forum and see others have asked the question in the distant past, but have found no answers.
What I'm 'hoping' for is that someone has a sample app they are willing to share so others can see how to set this up.
Thanks in advance for any help or suggestions.
rickyT
View Complete Forum Thread with Replies
Related Forum Messages:
Employee Punch Clock
The company I work for has a central office and out employees work at different locations around the city. I have setup a database so that reports and requests made by employees are put into the database and sent to our office and clients office, instead of the tri copy forms we have been using. One thing that we were interested in doing was setting up a punch clock in the database so when employees come and go they punch in and out and there is a report that can be printed weekly or biweekly. Unfortunately I have no idea how to start making that feature, I would appreciate any help or advice on what direction to go...
View Replies !
Time Management - Simple Time Clock
Hi all, I havent' been around in a while (toddler, work, getting my BS degree and new baby coming in a week and a half) so I am hopefully not asking a previously posted question. I'm suspecting my new work isn't accurately paying for the hours worked. I made a quick simple DB where I input my punch times in short time format. There's the typical In, Out for Lunch, In from Lunch, and Out. I've got it correctly adding the times so that it reports the total hours worked per day, though, in order for it to display correctly, that total is in short time as well. The problem is, when I group a week together, as soon as the sum of the totals reaches 24 or more, it goes back to 0, as it's on the idea that there's only 24 hours in a day. Hopefully, it's just a formatting issue or is there a function to convert the times (or just the sum) to number of hours? Thanks and Happy New Year to all. -Jim
View Replies !
Realtime Clock
I've got 5 time zones showing on the main screen of my db, just by doing date() and subtracting number of hours for each time zone. Only problem is need a refresh button on it for people to click. Can you get a realtime clock ticking away on an access form?
View Replies !
Sync With Computer Clock
Hi, My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful, Thank-you for your help in advance, and i apologise for such a lengthy post! Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here. Chris
View Replies !
Adding A Simple Text Clock To A Form
Trying to make a simple clock inside my form. So far I got my clock but it isn't running. It only get's the time when I open the form but I want it to keep track of time. Searched the forums but couldn't find anything that relates to this problem.
View Replies !
Time Format - Short Time Displayed As Medium Time
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network. The link works fine but the time formats are different. On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM# Weirdly though, when you just open the table, the times are in the correct shorttime format. Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances? Any ideas? This screen shot may help:
View Replies !
Time Format - Short Time Displayed As Medium Time
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network. The link works fine but the time formats are different. On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format However on PC 2, opening the same database via the network, the time format is still short time but the format is in AM/PM or medium time. Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances? Any ideas?
View Replies !
Calculating The Total Time Of All Recorded Time (MS Access 2000 And 2003)
Hello, Here I am having a little bit confusion about how to calculate the total time of steps of a process (for example: registering a new user for a website) in MS Access: - step1: entering a user name in a text box will take 00:00:10,94 - step2: entering a user password in a text box will take 00:00:03,12 - step3: entering a user confirmation password will take 00:01:30,16 - step4: entering a user email address in a text box will take 00:00:07,79 so, the total time of each step will be 00:00:52,01 the idea is that I have two fields in a table named "Total Time". the first field i named it "Process Type", where I type each step of a process as I mentioned above. And the second field I named it as "Timing", where I type the time manually for each step. in a form, there will be a control source "text box" that will calculate or sum all time that are in the "Timing" field which are listed manually by me. I need a solution of it, because it is my first time to deal with this concept????
View Replies !
Having A Combo Box With A Time Greater Than The Previous Recordset Time.
I am currently trying to have a subform which has a start time and a end time in each recordset. My problem is I want the end time to only give out values greater than the start time. Im using a combo box to look up values in a table, and then a query in the end time box to look up values greater than the start time. This works fine in the first record, but in the second record the end time is only greater than the start time of the previous record NOT the the current record. How can I set it so Record 2's start time choice starts greater or equal to the previous records start time and the end time is greater than that records start time? Thanks for your help.
View Replies !
Ignore Time In Date And Time Field
Hi, Wonder if someone can help please. I'm quite new to Access so please bear with me. I have a data field in my database consisting of both a date and time. I then have a form containing two fields where the user can type a 'To' and 'From' date to extract the records that they are interested in. The query behind this uses the 'Between[Enter The Date] And [Enter The Date]' coding. The problem is that because the field contains a time it doesn't return any records when I run the query. Can anyone offer a bit of guidance on how I could ignore the time part of the field perhaps by adapting the above. Many thanks Chris
View Replies !
Hard Code TIME To Selected Date On Form (to Make It Date&time) For My Query Criteria
Hello buddies :D, do you have any idea how to make this work? To select data that falls within this criteria of date range between cboDate and cboDate2 (fields on my form). The date in [tblJobDetails]![timeIn] come in this format "08/17/06 10:24 AM", but the cboDate/cboDate2 (takes in date only e.g 08/17/06) what i am after is to evaluate specific hard coded time in addition to the date entered, i.e. even tho, i haven't entered time on the cboDate/cboDate2, I want specific time hard coded where e.g If i select a date range of 08/17/06 and 08/18/06 on my cboDate and cboDate2 it should really be evaluating: 08/17/06 8:00 AM to 08/18/06 8:00 AM. This is the criteria i curentlly have on my query in design view tha works perfect in selecting date only. ([tblJobDetails]![timeIn]>=[Forms]![frmPendingJobs]![cboDate] Or [tblJobDetails]![timeIn]>=[Forms]![frmPendingJobs]![cboDate] Is Null) And ([tblJobDetails]![timeIn]<=[Forms]![frmPendingJobs]![cboDate2] Or [tblJobDetails]![timeIn]<=[Forms]![frmPendingJobs]![cboDate2] Is Null) How can I incorporate 8:00am to 8:00am into my cboDate and cboDate2. What can i do to make this happen? Your kindness will be greatly appreciated http://www.naijaryders.com/forums/images/smilies/thankyou.gif
View Replies !
Time In Access: Keeping "medium Time" Format
I've run into a bug, I think. I have a time field with it set to show "Medium Time" which is "hh:mm(AM/PM)", however, when I combine the information with another field in a query (=[OfficeDay]&" - "&[POfficeTime]), the time comes out as "Long Time" or "hh:mm:ss(AM/PM)". End result is Wednesday - 10:30:00AM when it should be Wednesday - 10:30AMDoes anyone know a way around this?
View Replies !
SQL To Get A Job Start Time And End Time??
Hi, I have a database that tracks jobs as they are being completed. I have 2 tables, the first of which contains details of the jobs and the second contains details of the individual tasks that make up each job (Job and Task respectively) Within the Job table, there are several fields, however the fields I am concerned with are JobKey, JobID, Start_Time and End_Time. Currently, as each task within a job is completed, a new entry is added to the Job table with an updated End_Time. At the end of a job, there will be several entries in the Job table similar to JobKey JobID Start_Time End_Time 1 1 10:00:02 11:00:07 2 1 10:00:02 11:01:14 3 2 10:02:12 11:24:45 4 1 10:00:02 11:02:34 5 1 10:00:02 11:05:25 etc When I query the Job table, I end up with multiple references to the same job, where all I really want is a single reference to a job with the JobID, Start_Time and the End_Time the last entry relating to a particular job. How would I write a query to give me a single reference to a JobID Start_Time and the final entry for End_Time? eg From the above, my query should return JobID Start_Time End_Time 1 10:00:02 11:05:25 2 10:02:12 11:24:45 Thanks for any help with this W1dge
View Replies !
Time
Dear All, I am not sure if this has been raised before, put after a long list of entries, i have given up. I have a start time of 09:00 and a finish time of 09:30 the total time is 0.30 easy so far, but when I times the total by an hourly rate the cost total is incorrect as it does not see 0.30 as 1/2 an hour (0.5), has any body got any ideas of how to over come this problem. Thanks for all your help in advance Alastair Lane :eek:
View Replies !
Run Time
I probably know the answer. Do I need to purchase another program to make a database of Access and all menus etc into a run time program. I just want my info to be easier for my secretary to use than being able to see all particulars and code etc if they hit the wrong button. I assume i need "Office Developer Edition". I also assume MS is probably going to charge a fortune for this.
View Replies !
Time
OK....so yes...I am a dummy....and need help to cure this headache. I have a user that MUST insert time.....in Minutes and Seconds only. I set the field to short time. However, whenever the user inputs anything over 24 (minutes) a message appears "The value entered for this field isn't valid"...etc. I know it's because it's trying to store the hour & minutes rather than minutes and seconds so I tried to format the field with nn:ss but still no luck. I know code is available for the purpose of datediff etc., but what I need is a little different. First, the user needs to feel warm and fuzzy that what she's entering is correct and second, daily the time is entered and monthly the daily times are totaled and averaged. I could sure use some suggestions here, if anyone has any. Thanks in advance.
View Replies !
How To SUM Time
Hi, I have an employee mastertb that has the following fields employee name, city, work catagory, logdate, a start time, a finish time and a duration time that defaults to 3 hrs if start and finish time are < 3hrs. The mastertb is updated on a daily basis at the end of each day. I want to create a table from the mastertb to show employee name, city, certain work catagories and sum the duration feild. However when I try to sum the duration in hours and minutes I get a number similar to 2.00001233 instead of hours and minutes as displayed in the mastertb? How do I format/sum the duration field??? Cheers ...DEZ...
View Replies !
Time
I have 2 fields which contains a start time and an end time (the difference between the two is usually between 1 to 6 hours). However, I am noticing that the data, in my fields are in the following format: eve_stime eve_etime 01/01/1900 16:00:00 01/01/1900 17:29:00 01/01/1900 17:30:00 01/01/1900 18:59:00 From the above example, i would like a new field which simply shows me the difference between the two times, in the above examples it should be approx 1.5 Any ideas on the best procedure to tackle this ? Thank You
View Replies !
Time
G'day, Ive Been Asked To Create An Access Database At My Work (unfortunately My Database Knowledge Is Not Great, And Im More Used To Oracle Rather Than Access). At The Moment I Have A Field Titled "time" Which Will Show When The Electricians Will Start A Certain Job (ie 09.05). I Have Managed To Create A Query Which Will Calculate The Length Of The Job, I Just Need This To Be Added To The Start Time So I Can Add A New Field Called Estimated Completion Time (basically Start Time + Job Length). I Also Have An Am/pm Field, I Would Like It To Display The Letter "a" When The Start Time Is Between 0800 And 1200 And The Letter "p" When The Start Time Is Between 1200 And 1700. If Anyone Can Help It Would Be Much Appreciated. Thanks In Advance
View Replies !
Using Between With Time
Hello, I have a query I need to run that will check a table with a datetime field with various dates and times. I need it to make a field a 1 if the time shown regardless of the date falls between 8:00:00 am and 12:00:00 pm. I need another field to show as 1 If it the time is between 12:00:01pm and 5:00:00pm and another one between 5:00:01pm and 11:00:00pm. I tried the following query, but the results are not calculating correctly. Can someone give me a hand? SELECT tbl_termcodes.DLListName, tbl_termcodes.DLList, tbl_termcodes.Account, IIf(Format([Calltime],"hh:nn:ss") Between #12/30/1899 8:0:0# And #12/30/1899 12:0:0#,1,0) AS [8-12], IIf(Format([Calltime],"hh:nn:ss") Between #12/30/1899 12:0:0# And #12/30/1899 17:0:0#,1,0) AS [12-5], IIf(Format([Calltime],"hh:nn:ss") Between #12/30/1899 17:0:0# And #12/30/1899 23:0:0#,1,0) AS [5-11] FROM tbl_termcodes; Thanks! Vassago
View Replies !
Sum Of Time
I've read a few different posts about adding time, but so far they have delt with different circumstances. I have a query which pulls 30 random records, with a duration time attached to them. I then want a second query to add all these records and give a total duration for these tracks. The time is in this format 00:04:03, but when I use the Sum expression in a query i get a result like this "0.0864699074074074" Any ideas how I can get it to be displayed in hh:mm:ss?
View Replies !
|
TRACKER
