INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Attendence

Attendence

(OP)
thread702-1741110: Attendance Calendar questions Continuing thread702-1723375

not to be too much trouble but can someone help me figure out a thing or two on this calender? I have been able to add my employees and get the weeks to start with Saturday and even get it to look back 365 days from today in the absentee report for a rolling year and a few other things. What I would like to do is remove the sub-form at the bottom of the year calender and (main input screen)and add a form that either just displays the vacation days used during this calender year showing or add that info to the absentee report itself. Any ideas? Thanks in advance!

RE: Attendence

1. How do you want to show the vacation days for the year? Showing on them on a calendar is not practical for an entire year. Personally, I would list them.
2. What version of Access are you using?

Laurie

RE: Attendence

(OP)
Hey Laurie, Thanks for your response. I am using 2010 Access. Here is a link to the calendar as I have modified it so far. oxicottin and MajP (from this forum) and Im sure a few others built and designed this calendar and it is really, really good...I take no credit for it whatsoever, simply a very grateful user. What I need to make it do at this point is to have it count vacation days used by calendar year Jan-Dec. and place the number at the bottom of the screen instead of the sub_form that is there now. I also, if it isn't too much trouble, would like to add a statement to calculate the number of vacation days available, here is what I have so far, but it wont let me enter it:

TotalVacDays:IIf([YearsOfService]<=0,0,IIf([YearsOfService]<=.5,5,IIf([YearsOfService]<=5,10,IIf([YearsOfService]<=6,11,IIf([YearsOfService]<=7,12,IIf([YearsOfService]<=8,12,IIf([YearsOfService]<=9,13,IIf([YearsOfService]<=10,14,IIf([YearsOfService]<=11,15,IIf([YearsOfService]<=15,16,IIf([YearsOfService]<=16,17,IIf([YearsOfService]<=17,18,IIf([YearsOfService]<=18,19,IIf([YearsOfService]>=20,0))))))+IIf([BoughtVac]=True,1,0)

It calculates based on years of service as of July 1 of each year. If you look at the reports at the top of the input calendar I need my absences, tardies etc to calculate on a rolling year, which I figured out. Vacation days however are calendar year and I would like to have those on the report as well. So I guess I would like two numbers at the bottom of the main form one showing Vacation days available, and one showing Vacation days used. Thank you for any insight you can bring.

RE: Attendence

Do you mean like this? This is what I did for my vacation.... This is the totals in the (subFormVacPDSDSummary). The syntax I used is:

=[txtVacHoursLeft]\8 & "d/" & [txtVacHoursLeft] Mod 8 & "hrs"




Hope this helps....

Thanks,
SoggyCashew.....

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close