form dilema!

[PattiP]

I am in the process of automating a daily log of events that shift operators
will fill out during their shift. There are 3 rotating shifts throughout the
day. The paper form that they had been filling out had the shift listed and
they would initial or sign their name by the particular shift they happened
to be working that day:

Shift 1 - 00:00-06:00 Fred
Shift 2 - 06:00-18:00 Sam
Shift 3 - 18:00-06:00 Sarah

The main form would have the date, shift and operator name

the subform would have the time of the event(s), the type of event(s) and
description.

I was going to have the shift hours as a label so all they have to enter is
their
name along side it. But I also want to store which shift they are on so we
could query by which operator was working at the time of a particular event.
If I used "Shift1", "Shift2", "Shift3" as fields and enter the operator's
name in each, I would be unable to query by operator. I also don't want them
to have to enter the shift number every day. I would like all three shift
times to show up automatically on the form each day.

any suggestions?

I am using Access 2000.

TIA,
Patti

 

[Sandra Daigle]

Hi Patti,

Anytime you are tempted to create a repeating group of fields in a table,
stop and think about whether you REALLY want to do it. In your case, your
table really should look just like your existing form:

EventDate
ShiftNum
StartTime
EndTime
EmployeeName
.. . . whatever else you need

It would be easy enough to write a little code that would create the new
shift records for a particular day and then have the form open as a
continous form with the prefilled date and shiftnumber.