P
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 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.
Is there some code that would automatically insert the shift when the
operator entered their name?
I am using Access 2000.
TIA,
Patti
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 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.
Is there some code that would automatically insert the shift when the
operator entered their name?
I am using Access 2000.
TIA,
Patti