Recent content by TriciaLatchman

I've done this however, i am still not able to save as i am getting the attached error.

Hi Mark, I am unable to save the file it is saying Read Only Mode.

I understand, i am in the learning process that why i'm asking fo help to build. If i see the steps of examples i will be better able to do accordingly. Please asssit.

Can someone please help me with figuring out what's wrong with the attached database. I can't seem to get the report "Entitlements and Balances" to pull the correct info for the Days Taken for the relative leave type. Please help! Thanks.

hi Mark, your comments are greatly appreciated

Hi Mark, understood....but i am still not fully clear on what should be done. So here's my scenario, Employee apply for leaves using a manual form (Physical Paper) which has a two-fold approval system. The form is is firstly approved by their immediate supervisor and then the HR Manager. The...

Hi Mark, Yes an employee will apply for a leave. Then I should create another table called tblLeaveApply with LaLeaveID LaEmployeeID LaDaysEntitled LaDaysUsed DaysLeft: Nz([LaDaysEntitled],0)-Nz([LaDaysUsed],0) Is this system designed to tell them what that leave will be? Yes, it should...

Hi Mark, See attached ContractLeave table with data. Can you please advise how i proceed now..thanks

Hi Mark, I understand, populating data into ContractLeave table. Regards TL

Hi MarkK, I an really new to access....i am tying to figure out where i put in the actual No. of days for each leave type. can you please clarify? Leave Type Days Entitled Vacation Leave 20 Days for 1-Year Contract 40 Days for 2-Year Contract 60 Days for 3-Year Contract 0 Days for Month to...

I have created the tables but i am still not sure how i calculate the entitlements based on the different contract terms. Is is possible to do a quick sample. i think i will be better able to understand there. thanks

Hi Guys, I am trying to create a database that track annual leaves for employees by entitlements. I have created a table named tblType_of_Leave with the following fields (PK) LeaveTypeCode = AutoNumber LeaveTypeDescription=Short Text Days Entitled=Number Leave Type Days Entitled...

Hello, I am pretty new to access....i am also a self taught user who has been using Access to make my life easier.... I have found that there are so many tasks that a database and a bit of automation can do to free myself of routine administrative work. My co-workers has been noticing and...