G Guest May 26, 2007 #1 I want to add "today's date" into a field everytime a new record is created. I have tried several things, with no success. Anythoughs?
I want to add "today's date" into a field everytime a new record is created. I have tried several things, with no success. Anythoughs?
M missinglinq via AccessMonster.com May 26, 2007 #2 Private Sub Form_Current() If Me.NewRecord Then YourDateFieldName = Date End If End Sub david said: I want to add "today's date" into a field everytime a new record is created. I have tried several things, with no success. Anythoughs? Click to expand... -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com
Private Sub Form_Current() If Me.NewRecord Then YourDateFieldName = Date End If End Sub david said: I want to add "today's date" into a field everytime a new record is created. I have tried several things, with no success. Anythoughs? Click to expand... -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com
R Rick Brandt May 26, 2007 #3 david said: I want to add "today's date" into a field everytime a new record is created. I have tried several things, with no success. Anythoughs? Click to expand... Make Date() the default value for that field in the table's design.
david said: I want to add "today's date" into a field everytime a new record is created. I have tried several things, with no success. Anythoughs? Click to expand... Make Date() the default value for that field in the table's design.
