473,327 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Attendance Database - Help with PTO Time

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.

Jan 13 '08 #1
3 4202
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.
Jan 13 '08 #2
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?
Jan 13 '08 #3
On Sun, 13 Jan 2008 02:35:10 GMT, Don Calloway
<dr********@verizon.netwrote:

There is no simple answer for your scenario; it would require some
analysis time to really think this through. I wrote such an
application once for a large company. Many business rules - including
different penalties for different kinds of absence. "Hire a competent
developer" is the best advice I can give.

-Tom.

>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?
Jan 13 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Richard Williamson | last post by:
Hi all, I have tables set up something like: Member(MEMBER_ID, name, etc) Event(EVENT_ID, eventname, place, time) Attendance(MEMBER_ID, EVENT_ID, present) I am trying to bring up a form...
4
by: spnz via AccessMonster.com | last post by:
Hi there I am hoping for a little bit of advice on creating an attendance report. I work for a company that employees a large number of temp staff and I need to monitor their attendance. I...
1
by: Kevin | last post by:
Hi, I have an attendance database that tracks when employees are present during the week. I have a two tables that have the following information: EmployeeTable with Fields EmployeeID, First...
2
by: crier_67 | last post by:
Hello all, I'm relatively new to Access and could use some direction on this task. I have a group with a FoxPro 2.6 for DOS membership & attendance database with about 200 member records. ...
1
by: Shun | last post by:
Hello, My requirement is to develop an Employee Attendance Register. For ex: I am in some X country and my office is in Y country. now my requirement is i want to check the employees present...
2
by: timgeitz | last post by:
I would like to design a drop down option box on a form which gives me several choices for putting in an attendance date to record church attendance. Typically, a church secretary would record a...
0
by: Bill | last post by:
I've searched comp.databases.ms-access for a solution and found help but still haven't got my problem solved. I want to record weekly attendance and print an attendance "check off" sheet where...
18
by: yashumrhsn | last post by:
can anyone help me to get userid and password from access database..then it compares the userid and password and opens a new from that shows the details from the database for that user..
5
by: Lindie | last post by:
We use a spreadsheet to record attendance for pupils with special needs. They live-in so we need 365/365 attendance details. The spreadsheet is getting too cumbersome, a Db is needed. I would...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.