Yearly Attendance Tracker/Calendar

I cannot get the .zip file to allow me to save onto my computer. Is there something i need to do in order to unlock the workbook?
 
oxicottin said:
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.
Click to expand...

Oxicottin, love your work on the Attendance DB!

I have a question which I'm hoping you'll be able to help me with. My date settings are mm/dd/yyyy. Your DB is configured to dd/mm/yyyy which means that all the dates from dd 1-12 are filed wrongly and the entries on the calendar remain invisible for those days (not highlighted).

McSwifty has suggested to add "format([datefield],"mm/dd/yyyy")" to the VBA code. However, I can't get that to work; I'm also not sure where I would add it.

I don't know if you still look at this older forum post, but if you could help me to change that so my UK settings work with your DB I'd sure appreciate it! I love the work that you did to the file. Thank you!
 
Hi Oxicottin,

I have also found you great database and would like to amend for my means.
You have a reference to Outlook 15 and I use 12, but it will not allow me to deselect 15 and so cannot select 12.
Would you have any idea as to why and get passed it.?
This applies to your Public_Attendance Control_v4.xx and Attendance Control Public v5xx databases?

TIA
 
Can u please fix it for Windows 64 bit thanks
oxicottin said:
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.
Click to expand...
 
McSwifty said:
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.
Click to expand...

Hi,
I have an issue with your database, the same one I have with mine - error 3075: Syntax error in date in querry expression.

It looks like a problem with date formating, but I can't resolve it.

All my previous databases work, even the date format is European, dd/mm/yyyy.
But with a code I've inserted from MSDN "Counting the Number of Working Days in Access 2007" I get the same error as with your database.

This line has an error:
strWhere = "[Holiday] >= #" & startDate & "# AND [Holiday] <= #" & endDate & "#"strWhere = "[Holiday] >= #" & startDate & "# AND [Holiday] <= #" & endDate & "#"

I tried it with US date type as this one below, but the same error appears:
strWhere = "[Holiday] >=#" & Format(startDate, _
'"MM/dd/yyyy") & "# AND [Holiday] <=#" & Format(endDate, "MM/dd/yyyy") & "#"

So could it be some difference with Access 2010 handles expressions? Maybe some reference for handling date?
 
I tend to do the following

Code: 
strStartDate = Format(Me.txtDateBW, strcJetDate)
strEnddate = Format(Me.txtDateWE, strcJetDate)
then
Code: 
strSQL = strSQL & " AND ((tblDates.DayDate) Between " & strStartDate & " And " & strEnddate & ")"
and in a module

Code: 
Public Const strcJetDate = "\#mm\/dd\/yyyy\#"  'Needed for dates in queries as Access expects USA format.
Then it does not matter what format your date is.
All I need to do then is remember the constant name. :)
 
Re: NEW VERSION V5.xx

oxicottin said:
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?
Click to expand...
 
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?
Click to expand...

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.
https://www.tek-tips.com/viewthread.cfm?qid=1723375
https://www.tek-tips.com/viewthread.cfm?qid=1773045
 
Last edited:
MajP said:
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.
Click to expand...
 
MajP said:
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?
Click to expand...
 
The year calendar form is a view of what is in the tables. So it sounds like you just need a simple query that returns absences per person for the year selected.
 
Sorry for not replying MajP did most of the work and I'm super busy with work... Attached is the newest version if that helps anyone....
 

Attachments

On a side note I think what your after is one of the end report buttons on the calendar.
 
I like the changes you have made to the newest version.....

One thing that im trying to be able to do is put a combo box instead of a text box for absence reason. I want to have the reason be consistent with all supervisors.

What would I need to change to switch out those two?
 
What form are we talking about and what text box?
 
One thing that im trying to be able to do is put a combo box instead of a text box for absence reason
Click to expand...
that does not make any sense. There is already only a combobox.
 
MajP said:
that does not make any sense. There is already only a combobox.
Click to expand...

The combo box is for AbsenceID. The text box is for AbsenceReason. I was trying to turn the text box (AbsenceReason) into a combo box.
 
So what I'm getting is your trying to do is create a list of "reasons" like:

took a poop
went to lunch
Got abducted by aliens
Truck is stuck in four-wheel drive
Bla bla bla

That you want to populate in a combo box instead of you typing reasons. Am I correct?
 
You must log in or register to reply here.

Similar threads

A
Calendar events but not in Outlook
Replies
13
Views
648
Pat Hartman
P
C
Automated Production Planner
Replies
11
Views
719
GPGeorge
GPGeorge
J
Lookup and assign value based upon text within alpha range
2
Replies
35
Views
686
Pat Hartman
P
Steve R.
Drone Hysteria
2 3
Replies
46
Views
1,521
The_Doc_Man
The_Doc_Man
MajP
Attendance tracker
Replies
2
Views
1,102
Gasman
Gasman

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom