K
Ken Curtis
I have a form which is used to record all "contacts" (i.e. date and content
of phone, fax and email contacts) which are made to our agency daily. The
first field is "Date of Contact", its input mask is set for short date. The
information comes from notes hand written in a general log by day staff, and
is entered into the data base form by overnight staff.
To speed up data entry, I would like the "Date of Contact" field to fill
itself in automatically AFTER Tab is hit and the field looses focus.
However, because overnight staff is entering data from a previous day (i.e.
they enter contacts from January 1 on January 2) the date entered
automatically must be "yesterdays" date, not "today's" date.
ALSO ... and very important ...
Even with the field set to automatically display (hopefully !!)
"yesterday's" date, there is the issue of backlogging: Sometimes it is
necessary to enter a contact out of sequence (i.e. a missed contact from
December 30 needs to be entered on January 2) which means that the field must
allow manual input (using the input mask) even though it has been set to
enter "Yesterday's" date when Tab is hit.
How can I possibly tell the field all this?
Thanks for your thoughts / help.
Ken Curtis
of phone, fax and email contacts) which are made to our agency daily. The
first field is "Date of Contact", its input mask is set for short date. The
information comes from notes hand written in a general log by day staff, and
is entered into the data base form by overnight staff.
To speed up data entry, I would like the "Date of Contact" field to fill
itself in automatically AFTER Tab is hit and the field looses focus.
However, because overnight staff is entering data from a previous day (i.e.
they enter contacts from January 1 on January 2) the date entered
automatically must be "yesterdays" date, not "today's" date.
ALSO ... and very important ...
Even with the field set to automatically display (hopefully !!)
"yesterday's" date, there is the issue of backlogging: Sometimes it is
necessary to enter a contact out of sequence (i.e. a missed contact from
December 30 needs to be entered on January 2) which means that the field must
allow manual input (using the input mask) even though it has been set to
enter "Yesterday's" date when Tab is hit.
How can I possibly tell the field all this?
Thanks for your thoughts / help.
Ken Curtis