Hello Kambiz
Set the DefaultValue property of your textbox to =Now().
If you just want today's date, without the time, then use =Date() instead.
Good luck and Happy New Year!
Graham
_____
Graham Mandeno
Microsoft Access MVP 1996 - 2014
Graham
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Sunday, 28 December 2014 08:43
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Today's Date
Thank you Crystal,
What I like to do is when end user add a new record date and time be
automatically "Now()" enter into its field and would not change if record is
edited.
1. As you instructed I used:
If Me.NewRecord Then
Today = Now()
End If
it did not work, please help with code.
2. The field in question should be Date/Time or Text field?
I remain as always
Kambiz
[Non-text portions of this message have been removed]
Posted by: "Graham Mandeno" <graham@mandeno.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar