Entering Date and Time in a Field automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a field on my form that is a date/time data type. The field is used
to log in the date and time a job is submitted to our department. Instead of
manually typing the date and time the job is submitted, I'd like the
supervisor to be able to somehow "select" the date and time. Can I automate
the process of entering date and time into this field?

Thanks,
Rosemary
 
Several options:
1. Put Now() as the default value of the date text box on the form.
2. Put Now() as the default value of the date field in your table.
3. The supervisor can use a shortcut key. (CTRL+; enters the current date
and CTRL+SHFT+; enters the current time)
4. Put code in the double-click event of the text box to enter Now() so the
supervisor can double-click to make the entry.
 
Back
Top