On Sat, 12 Jan 2008 19:12:03 -0700, Tom van Stiphout wrote:
On Sat, 12 Jan 2008 17:44:31 -0800 (PST), lucky33
<ki*******@bellsouth.netwrote:
You could each day when the app starts up see if there are any new
records to be added.
I would probably rather write a VBA function that given the hire date
returns the number of PTO hours accrued.
-Tom.
>>My employer has asked me to create a database that will keep track of
the employee attendance. Time off / Time earned, excused / unexcused,
etc.
At my company from the 6th month of employment to the second year you
earn 8 hours of PTO each month, from the 2nd to 4th year you earn 10
hours PTO each month.
My question is how would I preform a check for each employee once a
month to automatically add their newly earned PTO time?
Something like - If today's date - employee A start date 7 months add
8 PTO hours etc.
I know I probably confused everyone reading this, but any help is
greatly appreciated.
I've got an even tougher problem for you. At my place of employment, as
a supervisor, I've used an ACCESS database I constructed to maintain my
employees time and attendance in such a way as to give me each of their
leave balances and tenure for any given day I enter into a dialog box
(form). There is an input form for entering each employee's annual, sick
and holiday leave taken, and also leave and tenure accrued. Where I
work, an employee who has between 0-5 years tenure earns 5 hours annual
leave each semi-monthly pay period; between 6-10 years, 6 hours; between
10-15 years 7 hours and for 15 years and up, 8 hours. And, every
employee earns 6 hours sick leave each pay period regardless of tenure.
Because there is a payday twice a month, this means leave accrues on
payday, which means some months it accrues on the 16th of the month and
others the 15th. I've never taken the time to automate this in my
database, so I have to enter leave and tenure accruals manually for each
employee every payday. I believe there should be a simple way to have
the database check the date on startup (use the VBA Date() function
perhaps) and have the Time_and_Attendance table update leave accruals and
tenure earned for each employee each month, perhaps through an Update
Query that executes via a macro triggered by the main form load event.
Does anyone have any experience in this area that can lend some advice as
to how this can be done?