R
Rosemary
Hi,
I have a checkbox on my form called "Turnover". I would like to code the
checkbox so that it is checked automatically, depending on the following
criteria:
Jobs brought in to our department are logged in, and a field called
"ClockedIn" records the date/time the job was submitted. It's a textbox, and
the DoubleClick event is coded so that when the user double-clicks inside the
textbox, the current date and time appear (NOW()).
When the department closes for the day, the supervisor goes through and
checks the "Turnover" checkbox for all jobs still open.
I have another checkbox called "Completed". This box gets checked when a
job is done.
What I'd like to do is this: just after midnight (that is, at the start of
the next day), all jobs still left open (that is, the "Completed" checkbox
has not been checked) will automatically have the "Turnover" checkbox
checked. In addition, I want the "ClockedIn" field for those jobs to be no
longer editable.
Can I accomplish this with an If . . . Then . . . End If statement? Or, how
can I code the form to accomplish this?
Many thanks,
I have a checkbox on my form called "Turnover". I would like to code the
checkbox so that it is checked automatically, depending on the following
criteria:
Jobs brought in to our department are logged in, and a field called
"ClockedIn" records the date/time the job was submitted. It's a textbox, and
the DoubleClick event is coded so that when the user double-clicks inside the
textbox, the current date and time appear (NOW()).
When the department closes for the day, the supervisor goes through and
checks the "Turnover" checkbox for all jobs still open.
I have another checkbox called "Completed". This box gets checked when a
job is done.
What I'd like to do is this: just after midnight (that is, at the start of
the next day), all jobs still left open (that is, the "Completed" checkbox
has not been checked) will automatically have the "Turnover" checkbox
checked. In addition, I want the "ClockedIn" field for those jobs to be no
longer editable.
Can I accomplish this with an If . . . Then . . . End If statement? Or, how
can I code the form to accomplish this?
Many thanks,