How to INSERT TIME

[Guest]

Hi,

I need some Help.........

I want to insert system time when I run a Macro and that should not be
update like now() function.

And any chances to hide that particular cell which I entered the time and
this should not be visible to other users.

Narayan PSL

 

[John Vinson]

Hi,

I need some Help.........

I want to insert system time when I run a Macro and that should not be
update like now() function.

And any chances to hide that particular cell which I entered the time and
this should not be visible to other users.

Narayan PSL

Are you doing this in Access? Your use of the term "cell" and wanting
to hide the "cell" suggests you may be using Excel.

In an Access table, you can set the DefaultValue property of a field
to Now() to get the date and time that the record was initially
created; you don't need to have the field visible on your Form. Time()
will store the current time (but of course you'll have no way of
knowing that it's 10:41:37 on any particular day!)

John W. Vinson[MVP]