Time Clock App in Access
- Thread starter jawilli1
- Start date
An app in Access that a person can put in their Volunteer ID number and then click "clock in" then when they are getting ready to leave they can click "clock out". This will need to put the time and date in a database table, that I can then run a query run and see how much time they worked within a defined date range.
- Local time
- Today, 12:32
- Joined
- Feb 28, 2001
- Messages
- 30,557
As a basic design issue, you should be aware that Access doesn't manipulate time accumulation very well without a little help and a LOT of understanding. Date fields have an "offset" or "bias" amount - the number of days since the reference date. So you can subtract date fields, but the units are DAYS and fractions thereof. When you accumulate times in that format, Access wants the bias to still be there. Its formatting routines assume that. Incorrectly assume it, of course.... If you are up on your math theory, you know that the difference between two biased numbers will eliminate the bias amount, leaving the true difference behind. So that's good. But the Access assumption regarding that bias is bad.
As part of your design, you CAN subtract times to get time differences. You CAN add these differences to accumulate times. But when you try to format things, THAT step is where the **it hits the fan. 'scuse me, I need to put that in GovSpeak to be more polite - where the foetid biological mixed-phase ejecta impacts the blades of the rapidly rotating atmospheric destratifier.
Anyway - the units of the differences (and therefore of the accumulation) will be days and fractions thereof. To convert this to hours, convert the date to DOUBLE format (see function CDbl). Multiply it by 24 to get hours and fractions, in which case you can just format the output to a convenient number of decimal places past the hour. One or two should be plenty. But don't assume that you can quite so easily convert that number to HH:MM format without some specialized code.
As part of your design, you CAN subtract times to get time differences. You CAN add these differences to accumulate times. But when you try to format things, THAT step is where the **it hits the fan. 'scuse me, I need to put that in GovSpeak to be more polite - where the foetid biological mixed-phase ejecta impacts the blades of the rapidly rotating atmospheric destratifier.
Anyway - the units of the differences (and therefore of the accumulation) will be days and fractions thereof. To convert this to hours, convert the date to DOUBLE format (see function CDbl). Multiply it by 24 to get hours and fractions, in which case you can just format the output to a convenient number of decimal places past the hour. One or two should be plenty. But don't assume that you can quite so easily convert that number to HH:MM format without some specialized code.
The_Doc_Man said:
Well I didn't really understand quite what you were saying in that second paragraph, but I do get the gist of what you are saying. I am able to make a query to get the values that I need, the problem lies with making the application to get the values into the table. That's where I run into my issues. I really have no clue on how to gather this data from an interface. I've found a few interfaces that will work but how to get the data into the table is where I run into problems. That's why I could really use a sample app, basically something to guide me in my journey.
Thanks A BUNCH for any assistance you can give me with this matter
