Employees Leave management

[palani1976]

Hai guys Iam looking out for a sample DB for employees leave management.
# With leave application form
# Leave approval form
# Leave status
# All with username and password

Kindly help me out.

 

[Len Boorman]

Okay so what have you done so far and what problems have you encountered

L

 

[palani1976]

Hai

I have created a table for employee info and his respective manager.
I have created another table for employee leave application form.
Leave Form also ready.(With leave status in combo box "On Hold", "New", " Approved", "Rejected")
Leave approval form is also ready.
Leave status form is ready.
I have idea about picking up current network user.


Problems:
How to give leave sanctioning power only to approving manager?
How to make Leave approval form of the manager to show no of applications pending for approval?

 

[Len Boorman]

I suggest that basically
You already have an association between Employee and Manager. Now if this also has the Managers Network Logon id it will be possible to
a) Have a button on a form where the On Load Property of the for has an If statement whereby if the condition ( Certain Logon ID's) is true the Button is visible. This Buttontakes yoy through to an Approve Leave Form.

b) The Approve Leave Form lists those Pending Requests for those Employees whose Manager has the detected Ntework Logon.

Then all you need to do is detect the Network logon ID

I have a sample database with all the bits in that I cannot post because it is too big but if you PM me with an email address I will certainly send it to you.

Basically there is an Autoexec Macro that opens a form that can sit inthe background that reads the Logon ID and actually the PC name.

Len

 

[emmawillaim]

Thank You...