Now
Using the NOW Function
In this tutorial you will learn how to use the NOW Function.
The NOW function returns the current system date and time.
=NOW()
The result is 09/08/2014 16:49:33.
UK Date Format
FORM
In a Form you could set the Default Value of a Textbox to
=NOW()
VBA
In a Form add a TEXTBOX control and rename it "txtNow", then you could add the following in the Load Event.
Private Sub Form_Load()
txtNow = Now()
End Sub
Courses
Access Beginner 3
|
Access Beginner 9
|
Access Expert 8
Access 104
Seminars
Access SQL 2
Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
|