How can I input automatically into a table (via a form) the date and time of a transaction. Thanks
C Christina Feb 25, 2009 #1 How can I input automatically into a table (via a form) the date and time of a transaction. Thanks
T Tom van Stiphout Feb 25, 2009 #2 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
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
C Christina Feb 25, 2009 #3 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...
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...
