Column getDate()...

mase112

New member
Local time
Today, 04:12
Joined
Nov 10, 2005
Messages
7
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 ?
 
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.
 

Users who are viewing this thread

Back
Top Bottom