Recording Date and Time--More Info Needed

[Guest]

Earlier today I submitted the question, "In an Access form set up to allow
users to only create a new record, how can Access record the date and time of
the record creation." I add now that I want the Date and Time to show in a
control in the record that the user is creating.
Ricky Hicks suggested, "Use the 'Before Insert' event of the form to
populate the date and time value. This event triggers when the first
character is typed in a new record ..."
I tried this by trying to build an event but I just don't know how to
do this yet. Can someone clarify the steps or suggest a different way
please. Thanks.

 

[Steve Schapel]

Hughie,

My suggestion in your earlier thread was:
"Assuming you have a field, Date/Time data type, in your table for
DateCreated or whatever you have called it, you can have a textbox on
the form which is bound to this field. To get it to automatically log
when the record was created, just set the Default Value property to
Now(). This can be done in the Default Value property of the field in
the design of the table, or the Default Value property of the textbox on
the form... in this case it probably doesn't matter which you choose."

Is there anything you don't understand in my answer? Or something you
don't like about this approach?

By the way, it will probably be helpful to all concerned if you can send
a reply to the reply in the newsgroup, rather than starting a new thread
(topic).

 

[Guest]

Sorry Steve,
I was so rummy last night from trying to figure this out that I forgot I
posted last night. And there I went again with a new post on the same issue.
That post contains my response to your suggestion which I won't repeat
here. Your suggestion worked great except for the actual creation time not
being the same as the time at which the rest of the record would be
completed. Thanks and the etiquette suggestion is noted.