date and time

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

How can I input automatically into a table (via a form) the date and time of
a transaction.

Thanks
 
On Tue, 24 Feb 2009 19:59:01 -0800, Christina

In the form's BeforeInsert event write:
Me.myDateTimeField.Value = Now()
(of course you replace myObjectNames with yours)

You can also make Now() be the default value for your field, in table
design view.

-Tom.
Microsoft Access MVP
 
Thanks. Got it
Tom van Stiphout said:
On Tue, 24 Feb 2009 19:59:01 -0800, Christina

In the form's BeforeInsert event write:
Me.myDateTimeField.Value = Now()
(of course you replace myObjectNames with yours)

You can also make Now() be the default value for your field, in table
design view.

-Tom.
Microsoft Access MVP
Click to expand...
 
Back
Top