Time Clock App In Access
Has anyone ever made a time clock application in Access? If so, can you post a sample application? I'm really at a loss with this one..
Thanks,
Cran56
View Complete Forum Thread with Replies
Related Forum Messages:
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 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 !
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 !
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 !
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 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 !
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 !
MS Access Run Time
I want to know more about the MS Access Run time edition. If I prepare pakage in MS Access and installed in one server, shall i share the forms in client computer using Run time? Pls. give more details. Regards
View Replies !
First Time Using Access
Ok i have a few issues with my database, basically i have a form with a subform running from two tables. These tables are to record faults and the subform holds any updates and progress made. Basically i am trying to make a facility that only prints out the current job being looked at in form view, but i want it to print in a printable view as apposed all the graphics on the form. As well as this i have created a form and on this form i have a combo box which contains equipment! how do i create a filter type thing so when i select the appropriate equipment and run a macro it gives me a report only on the forms with said equipment. I am poo at SQL and scripting so if anyone can help me i will be very happy!
View Replies !
Access 97 Run Time Installer?
Hello, I have a roof-estimating program that I made in MS access 97. I want to sell it to online. However the buyer will have to have access 97 installed on their computer to be able to use my program. Is there a way to allow users to use my program with out them having access 97 installed on there computer? And if so how involved is it to make this work? I’ve been reading about the access developer’s extensions for access that makes a run time version of an access program. Will this work in my situation. I’m using access 97. I've seen some web sites with run time installers. Do these programs really work like they say? Will I need to re-write my program? And if I do need to re-write it, is there a certain way that it needs to be written in order for this to work. Please Help Thanks Chuck patentinv@sbcglobal.net
View Replies !
Access Run Time Problem
I have created and installed a package using the Office Developer Tools to create a package to deploy a database that I have made. I have also used this to install the Access runtime. On one PC that I installed the package on (XP Pro), when the database is opened several buttons do no appear and some code that I have written will not run. The buttons are actuallly there and you can click on them but you just can't see them. On a different PC on the same network I installed just the Access Runtime with just the runtime installer and the the database is fine. I have uninstalled and reinstalled the Access Runtime on the offending PC with no luck. Any suggestions?
View Replies !
Access 2000 Run Time
I have a rather large project that has been developed in Access 2000. Generally all my distributions have been to PC's with Access available. However, I do find that there are a few that don't. Obviously this is where Run time would be useful. Having never used it I have a few questions if someone could possibly help:- 1 If I have a program developed in Access 2k can it be converted to the MOD version to include runtime? 2 If there is a conversion process is it automatic or does it require extensive reworking of the project? 3 Is it still possible to purchase MOD 2000 or do I need to get an updated version and if so will that still work with Office 2k? Thats about it. Thanks
View Replies !
Access Help With Time Intervals
Hi, I am just learning Access and are having problems dealing with time intervals. My database form is seperated into two tables and in each column of the tables there are different time periods. The time periods are created by having two columns and one column is the start time while the second column is the end time.The problem is that in order to tie the two database together i have to group the database use the time periods as a key. But since the two tables time periods are different, i have to first seperate time intervals to specific months. My plan first is that using queries, i will insert new rows and in those columns i will have both the start month column to end month column both be the same month, but i could never figure out how to duplicate my information and change only the month. Now i am at a loss and i really need help for the project. I am sorry for the poorly worded explanation but i can't think of a easier way to say it. Please advise me on what to do and thank you for reading. Best Regards, Kane
View Replies !
Run Access In Run-time Environment
Hi, I was wondering if anyone would be able to help me here. I have a database created in Access .MDB. It operates allright on my machine. However, since this database is done for my client, i have a problem i need to ask for help. My client doesn't have microsoft office software installed on their machine. So when i passed the database onto them, they somehow can only run it in the run-time environment. Don't ask, I'm not sure about this at all. Anyway, They came back to me saying that they have got a run-time error message in the middle of running the database. On my end, it's hard for me to debug since it works fine here. I was wondering if anyone would be able to tell me how i could have this database run in the run-time environment as my clients do. This way, i could debug the problem. Is it possible for me to run my access database in run-time environment? how do i do that? Thank you in advance
View Replies !
More Than A User To Access The Db At The Same Time
Hi all How are you? I have a small problem... I have an access db called MainDB, which has tables, queries, data entry form. This db (MainDB) is located in the network server. I have another access db called BranchDB. This db (BranchDB) has no tables, it has linked tables to those tables from the MainDB, and it has the forms for view only (No Data Entry). The problem is that users from there local machines can not access the BranchDB at the same time. What can I do? Your help will be highly appreciated.
View Replies !
Unix Time In Access
hi all I'm using MS Access 03 to run some queries on a SQL database. 2 of the columns i pull from SQL are about time, but are stored in 'unix time'. can this be converted once in Access to a more readable format eg ddmmyyyy? any help would be much appreciated
View Replies !
Access Time Formating
I am constructing a databse for Time and Attendance and wish to have a cumulative total column for the hours worked in the month, the Time in/out, lunch and TotalHours fields are using the ShortTime format but when the total hours exceed 23:59, obviously the field will not accept this Data, any ideas how i can record the TotalHours worked in a month. Many thanks in advance for any suggestions.
View Replies !
Date And Time (SQL Vs MS ACCESS)
Hi guys, im really unfamiliar with MS access so could use a bit of guidance. I have an SQL server back end and MS access front end, im trying to run a simple date query to look at records with todays date only. In sql it would be something like: - SELECT Contract, convert(char(10), DispatchDate,103) as [Dispatch Date] FROM BinLocations where convert(char(10), DispatchDate,103) = (select convert(char(10), getdate(), 103)) I know i can use date() within MSaccess, but not sure i would convert the datetime field within sql to display this in msaccess. Anyone have the ms equivilant to my sql query? Thanks in advance Note: datatype for this field within sql is date/time
View Replies !
|
TRACKER
