Staff Attendance database

[UK EXCEL MAN]

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

 

[Duane Hookom]

"Tables all set up"... Do you mind sharing?

 

[UK EXCEL MAN]

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.

 

[Duane Hookom]

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.

 

[UK EXCEL MAN]

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.

 

[Duane Hookom]

Don't use lookup fields http://www.mvps.org/access/lookupfields.htm. Also,
don't store more than the staff code in the attendance table. Access is a
relational database.

 

[UK EXCEL MAN]

Ok lookups removed. Sorry didnt know.

Any ideas on the tab stops within the form?

 

[Duane Hookom]

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.