Attendance Layout

[jeffshex]

I'm looking for any advice on doing an attendance form that's easy for the end user.
I would like it to have a grid/excel feel to it since that is what they are used to.

I was thinking of having a form populate a list of people who are enrolled in the program and then entering 3 items: AttendanceDate, Status, and DailyPoint. I also need to snag to other key fields as well. Maybe do this on a daily basis, so I would prepopulate the current date or let them select if they forgot to do it that day.

I'm not sure about the best way for this, but I'd like for them not to have to go to every record one by one just to enter the attendance info. It would be much easier to have it on one view and then do an insert from that 1 view into the Attendance table.

Here's my table info FYI.

========
tblGeneral
GeneralID (PK)
FName
LName
=========
tblProgramInfo
ProgramID (PK)
GeneralID (FK)
StartDate
EndDate
=========
tblAttendance
AttendanceID (PK)
ProgramID (FK)
GeneralID (FK)
AttendanceDate
Status
DailyPoint

 

[SkipVought]

Hi,

attendance form that's easy for the end user.

Easy for the end user to do WHAT?

Inquire about their own attendance?

Inquire about other attendees attendance?

Daily, Weekly, Monthly, Annually, Other duration, fixed or variable?

Update & approve their own attendance, for what period?

Is manager approval required for attendance, for what period?

.......

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[jeffshex]

They are going to input other's attendance on a daily basis.
No manager approval required or anything else. Plain and simple, just looking for an easy way for them to input anywhere from 5 - 20 people's attendance each day.

I'm working on a form now where you select a date and the code runs a query and attaces as the record source. The query looks to see if they were enrolled into the program on that day they are doing attendance and puts in their IDs and name. It also lets them put in the other info as well.
It is just a query with an outjoin to include all info from the program table and anything from the attendance table.

I'm not happy with it and it doesn't seem to be quite there, but hopefully you understand the end game.