Column getDate()...

[mase112]

I have in mssql a column where i want the date of the day that it has bin made.

I am using this in a ms access forum where i create contracs.
And when a contract is created, i want to have in the column the date that it was created.

must i do it whit a Trigger or Stored Procedure ?
Or can i do it whit ms access VBA ?

 

[DJN]

Add a new field to your table DateCreated. Data type Date/Time. I am assuming you have a button to add a new record here,If so add a new line of code.

Me!DateCreated = Date

Or, you could put the same line of code in the after Update event of the primary key field.