Insert Date & Time on click

[SnackBar]

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

 

[Jeff Boyce]

You could add something like the following to the "Click" event in the
control on the form ... you ARE using a form, right?!

Me!txtMyCurrentDateTime = Now()

(substitute the name of your control)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[SnackBar]

Cracked it.

Thanks Jeff!

You could add something like the following to the "Click" event in the
control on the form ... you ARE using a form, right?!

Me!txtMyCurrentDateTime = Now()

(substitute the name of your control)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John Spencer]

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
..