Insert Date & Time on click

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

Guest

Hi

I have built a database to replace an old Job Clocking Card system in a
factory. When the user enters their job details and presses submit i would
like the Date and Time to be automatically placed into a table with fields i
have already defined and Data and Time.

Is this possible? Is so does anyone know the VBA/Marco for it or point me in
the right direction.

Would greatly appreicate it if anyone could help.

Kind Regards

Adam Gale
 
You could set the defaults for the fields to
Date() and Time()

That way the current date and time will automatically be entered when the
record is started.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top