Vacation / Day off Employee Database

[JennDavila]

Hello,
I am running into an issue with adding a form that displays a calendar to where the manager can click a day and it will attach itself to a tracking table. I am new to this and have been given this project as a learning exp. I need all the help I can get on where to begin.

I have created tables- one of with employee information, another with reason codes for day off requests (such as jury duty, vacation, sick time, etc). And a table of Approval codes (such as what manager approved the time off)

My vision is to have this database where I can do all of the below>
1. enter new vacation by day not start and end time.
2. Run query for taken vacation days (for scheduling conflicts)
3. Run Yearly Summary to see how many Vacation days are left for each employee.
4. I want the employee to click a button a form open and they drop down to their name, drop down to reason code, and approval code, and a calendar that chooses the day off. (and comments if needed)

***Is this way over my head to create?

Thx Jen

[NeoPa]

I'm sorry Jen, but this is well beyond the scope of the help we offer here.

We are not a code or project production service but we aim to help people where we can by answering their Access related questions.

Welcome to Bytes!

[JennDavila]

I'm sorry Jen, but this is well beyond the scope of the help we offer here.

We are not a code or project production service but we aim to help people where we can by answering their Access related questions.

Welcome to Bytes!

Thanks, but I wasn't trying to ask you to do it. I think I needed more direction on creating my form combo boxes. But I figured that out and now I am on to a different area of confusion. I took this one off of the forum not sure why it is still there. Thanks for your help though.