Staff Attendance database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like help to set up a general absence log of teaching and non
teaching staff at a school. A form needs to be set up where one can enter
daily a staff code, reason and am/pm or all day absence. If extended
absence, date range automatically includes absentee on daily report. Two
additional reports, one weekly and one monthly simply stating code and name,
from and two dates and reason. Tables all set up having problem setting form
automation and reports. Any help greatly appreciated. Any ideas or past
similar setups?
Thanks
 
By 'set up', I guess I mean Ive got a staff list of names, teacher true or
false, employment start and end dates and payroll numbers, also an absence
reason list made up of codes and reasons. I really just need an idea as to
the route to connecting them all and creating a basic database tracking
absence dates and reasons and supplying monthly and weekly reports. As you
can tell, Ive not done this before with Access and could use any and all
help. Thanks.
 
You need to create a table to store the attendance. Some fields would be the
primary key from your staff list, a date, and a code for the reason. You may
want to have from and to date fields.
 
Apologies for the delayed gratitude. I am facing a family crisis in the
midst of these enquiries.

I have created the table as you suggested and I have also started to work on
the form and here lies the crux of my problem. I have made the staff code of
the staff data table a lookup field within the attendance table but thought
that doing this would also auto fill the staff name field on the form. This
is not the case and wanted to know how I might go about setting an autofill
of the staff name field on the form. Also, tab stops on the form are closing
the form after completion of the last field. Is there a way to loop them so
that the user can check the record before ending?

Again thanks for your help so far. I will try to be faster with replies.
 
I don't understand how " tab stops on the form are closing the form after
completion of the last field". I've never experienced. There is a "Cycle"
property on your form that may help.
 
Back
Top