O
oxicottin
Hello, I am new at this so please bare with me.. I have a database built in
access 2003 and I have been keeping track of employee attendance. I want to
be able to bring up an employees name from a combo box and show thier
attendance on this calendar. I also have an attendance code (Text) that gets
entered for instance worked, Leave Early, Funeral, Jury Duty ect. I was
woundering if I could put a transparent box on top of each square in the
calendar for the attendance code to show for that day. I tried to make a
query in group by to pull the info from and as far as getting the dates that
the employee worked it just shows the gray square and I have to scroll threw
the records for each day instead of it all being visible on one calendar
month for that employee. My info is as follows:
tble_AttendanceCode =Text= Field Name Attendance Code
tble_Attendancedata = Employees Name(Text)
Attendance Date (Date/Time)
Attendance Code (Text)
tbl_EmployeesNames=(Text) Field Name Employees Names
Thanks!!
access 2003 and I have been keeping track of employee attendance. I want to
be able to bring up an employees name from a combo box and show thier
attendance on this calendar. I also have an attendance code (Text) that gets
entered for instance worked, Leave Early, Funeral, Jury Duty ect. I was
woundering if I could put a transparent box on top of each square in the
calendar for the attendance code to show for that day. I tried to make a
query in group by to pull the info from and as far as getting the dates that
the employee worked it just shows the gray square and I have to scroll threw
the records for each day instead of it all being visible on one calendar
month for that employee. My info is as follows:
tble_AttendanceCode =Text= Field Name Attendance Code
tble_Attendancedata = Employees Name(Text)
Attendance Date (Date/Time)
Attendance Code (Text)
tbl_EmployeesNames=(Text) Field Name Employees Names
Thanks!!