Search results for query: *

Oxicottin - thank you! MajP, What I am trying to figure is how many hours of time for vacations has been accrued up to 'today's date' during the current year. Our employees work 7 hours or 8 hours per day, and PT are 29 hours a week. If I can get hours I can figure the accrued time for days...

I posted an additional question on thread702-1741110: Attendance Calendar questions Continuing thread702-1723375. Oxicottin - don't know if you are following that one too. It is in regard to subFormVacPDSDSummary (figuring workdays per year minus holidays). Hope you can help. Thanks Stef

Oxicottin - I have a question on the summary of vacations etc. subform on the Yearly Calendar. I looked up the function fElapsedTime and it said that it counts all the time between two dates. When calculating how much time an employee accrues for vacation .833 a day here - it is based on days...

Nevermind...... :-O

Oxicottin.... Sorry about this - I can't unlock it.

Oh! FANTASTIC. Thanks!!

Thanks Oxicottin! I'll download today. Have to clean up the ones that you guys were using when building it. What a great program. I don't need the 'bought vacation' portion of it, and the way they figure vacation time here is 'different' but the bones are here and are exactly what I need...

I have run into another snag. The frm_YearCalendar appears to be working just fine - until I noticed that the dates/days are not in sync with 2014 - and instead match up to those of 2013. The date in the cbo box is correct. I again went back to the original download db and it is the same in that...

MajP - here is the link I am talking about. It's in the 1st thread. It's One Drive - which used to be Sky Drive. Can't get it here at work. May be able to grab it at home though on Google, but def. have Dropbox. Thanks...

oxicottin or MajP, Is there another place that I can get a copy of the Week View Calendar that you put on One Drive to share? Maybe a Dropbox link? We just got the full MO 2010 except One Drive. Thanks for your help. Stef

Only 201 replies? LOL You seemed to have worked it all out. But thank you for the explanation. I am going to be changing it a bit to fit other needs, but am learning so much from what is there - plus memory is being tweaked so I feel more comfortable. Happy Thanksgiving to you also.

Thank you! I had already changed one of them, hadn't found those other two instances yet. Will work on it in the am when I get back to work. Happy Thanksgiving to you and yours! Stef

Sorry - It is in reference to the Yearly Attendance form in thread 702-1723375 I haven't touched Access in the past 5+years (or any coding for that matter) it has been a real jolt to start thinking VBA again. The database is large and detailed. I have skimmed through most of the code trying...

Thanks Duane, great for future reference. Would that it was that simple. MajP - can you or Oxicottin help?

I have run into an issue with the frm_YearCalendar month of Decembember :-) When I went back and checked the original db I found that it also has this problem. When I click on a date to enter an absence I get a Run-time error '13': Type mismatch. When I click on debug the following (image...

Thank you MajP, I'm going to jump in and try not to sink! Will follow your suggestions.

I have been searching for an attendance calendar like this! Was there a final link to the finished product? It has been several years (5) since I last used Access and I have spent several hours going through this thread and getting familiar with the coding again and into the right 'mindset'...