here is a copy on my MediaFire... I use it in 2007 but it works in 07+.... A lot has changed I added a few things.
Here is the one I built in access 2003.... I have data for the year 2008 included so you can see what it does. click on dates to add data ect. there are alot if clickable images and text boxes on calendar so try them all. Hope this helps you and others.... Oh, I tried the "Yearly View" button and it gave me a debug on bold I would remove that and it should work. Everthing worked when I quit using it.
I think this sorts the issues - I hope.
I have Vacation as hours - I have also added the hours into the reports and underlying queries.
See attached file.
I have added a line of code to debug the issue you were having with StrgSQL.
If it errors out again with the mismatch error please post the debug from the VBA debug window.
If you have no issues you can comment out the debug line.
cheers.
strStartDate = Format(Me.txtDateBW, strcJetDate)
strEnddate = Format(Me.txtDateWE, strcJetDate)
strSQL = strSQL & " AND ((tblDates.DayDate) Between " & strStartDate & " And " & strEnddate & ")"
Public Const strcJetDate = "\#mm\/dd\/yyyy\#" 'Needed for dates in queries as Access expects USA format.
Sorry I haven't had time to upload the new version and I will soon but here is a copy on my MediaFire... I use it in 2007 but it works in 07+.... A lot has changed I added a few things, the bottom of the pic is cut off because my laptop screen is small so I just clipped the top half. Enjoy!
Hi Oxicottin,
I love your database and have a few questions on how I can edit a few things. Would you be able to help me out?
I love your database and have a few questions on how I can edit a few things. Would you be able to help me out?
If Oxicottin does not reply you can ask me most questions. I built the calendar controls for him and wrote most of the code modules. He built this from a demo I provided him.
If you need to understand how the code works you can check the original thread on Tek-Tips where this was built. In that thread I answer lots of questions on how it works.
That would be great. I will be reading through that thread today. I was wondering what exactly "Bought Vacations" mean and how that part of the database works.
That would be great. I will be reading through that thread today. I was wondering what exactly "Bought Vacations" mean and how that part of the database works.
If Oxicottin does not reply you can ask me most questions. I built the calendar controls for him and wrote most of the code modules. He built this from a demo I provided him.
If you need to understand how the code works you can check the original thread on Tek-Tips where this was built. In that thread I answer lots of questions on how it works.
Hi Majp,
Wow... you guys did a great job on this database. I was able to follow that thread you posted and it helped alot.
However, I am making a few small changes and I don't think I will be able to use the subFormVacPDSDSummary. I have employees with all different numbers of vacation days and they are not based on time since hire. Instead I am trying to calculate the number of Absences that are inputed into the frm_YearCalendar. What do you think would be the best way to do this?
What form are we talking about and what text box?
that does not make any sense. There is already only a combobox.One thing that im trying to be able to do is put a combo box instead of a text box for absence reason
that does not make any sense. There is already only a combobox.