Employee Earned Time

[Ernst Guckel]

Hello,

I have an employee database that has employee earned time tracked in a
table 'tblPaidTime' Earned time is sick, vacation, holiday, etc.
tblEmployees and tblPaidTime are joined by EmpID. What I am trying to do is
build a form that not only tracks the data but allows me to limit each paid
time type to a specific amount. I have a lookup table ltblPaidTimeType
defined as follows: PaidTimeTypeID, PaidTimeDesc.

I would put the limit of days per type in the lookup table but Employee
Position gets different amounts. I can store the limits in ltblEmpPosition
but that would limit the types of paid time ( I guess I could handle that.)

The real delima is how do I limit the entry of time based on employee
position and paid type on a subform of the employee form??

Ernst.

 

[Bob Quintal]

Hello,

I have an employee database that has employee earned time
tracked in a
table 'tblPaidTime' Earned time is sick, vacation, holiday, etc.
tblEmployees and tblPaidTime are joined by EmpID. What I am
trying to do is build a form that not only tracks the data but
allows me to limit each paid time type to a specific amount. I
have a lookup table ltblPaidTimeType defined as follows:
PaidTimeTypeID, PaidTimeDesc.

I would put the limit of days per type in the lookup table but
Employee
Position gets different amounts. I can store the limits in
ltblEmpPosition but that would limit the types of paid time ( I
guess I could handle that.)

The real delima is how do I limit the entry of time based on
employee
position and paid type on a subform of the employee form??

Ernst.

The ideal solution is to create an additional lookup table that
stores
1) PositionID, ( Foreign Key to ltblEmpPosition)
2) PaidTimeTypeID ( FK to ltblPaidTimeType)
3) LimitHours.

You then build code in the afterupdate event of tblPaidTime that
does a dSum() of the time entered in the table for a given employee
and time type, looks up the appropriate limit, then compares the
entered time to the limit and reduces the amount entered by the
excedent,