G
Guest
This one is interesting. On frmTempSchedule I have fields
for Sun-Sat. Form is set to Continuous Forms. Header
contains PayPeriod and Start/Finish dates. tblTempSchedule
has fields EID, LName, FName, PayPeriod, Start (date),
Finish (date), then Sun - Sat (text). How do I write code
to select a variable number of records (to be determined
and input by the user) then populate the Sun field (then
the rest later) with a value that correspondes to a shift
assignment for that day but will not populate a field with
a value (OFF or Vacation)?
The short of it - If I needed 20 workers at building 2 and
13 at building 3, selected at random, how do i populate
those fields without overwriting fields with OFF or
Vacation? Thank you for any help you can offer!
RP
for Sun-Sat. Form is set to Continuous Forms. Header
contains PayPeriod and Start/Finish dates. tblTempSchedule
has fields EID, LName, FName, PayPeriod, Start (date),
Finish (date), then Sun - Sat (text). How do I write code
to select a variable number of records (to be determined
and input by the user) then populate the Sun field (then
the rest later) with a value that correspondes to a shift
assignment for that day but will not populate a field with
a value (OFF or Vacation)?
The short of it - If I needed 20 workers at building 2 and
13 at building 3, selected at random, how do i populate
those fields without overwriting fields with OFF or
Vacation? Thank you for any help you can offer!
RP