getting time from system clock and importing into field in access

[Guest]

Is there a way to get the time from the system clock and import it into a
field in a table? I'm familiar with Access but new to SQL and do not know any
Visual Basic. Thanks.

 

[aaron.kempf]

=Now()
=Date()
=Time()

now = date/time
date = date
time = time

 

[Albert D. Kallal]

Are you talking about ms-access here?

Normally, you use the forms before update event:

me.MyDateTimeField = now()

 

[John W. Vinson]

Is there a way to get the time from the system clock and import it into a
field in a table? I'm familiar with Access but new to SQL and do not know any
Visual Basic. Thanks.

You can set the Default Value property of a table field to Time() to
get the current time (on December 30, 1899, the base of the date/time
system), or to Now() to get the current date and time, as of the
moment a new record is created.

You can also run an Update query updating a date/time field to Now();
or, using a Form, just type Ctrl-; (hold down the ctrl key and hit
semicolon) to fill in the time.

John W. Vinson [MVP]

 

[aaron.kempf]

eat shit fag I gave the correct answer first