New to Access, auto date issues

[Redcoat]

Hi all,
I'm new to access and have been creating a table to store data entered by machine operators about product quality checks in my factory. I can create the fields with the relevant data ok and make a form as the interface for the operators to enter the data but i am having trouble with the date and time.
What i need is for the date and time to be entered into the data base for each entry at the time of entry, but i need this to happen as an autodate type function as i dont want the operators to have the ability to fudge the dates or times.
I hope I have explained this well enough.
Any help would be appreciated.

Cheers,
Steve

 

[DrSnuggles]

In the DESIGN VIEW of your table, click on your Date field and under the Field properties; General Tab you'll see the property Default Value. Type in Now() in there.
That will put the time and date stamp on each new record.

 

[Redcoat]

Thanks Doc, how easy was that? I feel like a fool now.

 

[DrSnuggles]

Not at all!
It's all a learning curve and we're all in it together, whatever the level.

 

[bkuuz1]

Doc, I found your post from doing a search. Your explanation is almost exactly what I need except I don't want the time stamp. How do I get just the date stamp and I will have the same date stamp entered multiple times. Do I just use duplicates ok?

 

[namliam]

Why take the times off?
I would advice you to keep the times on your date/time stamps... you can always take the times off later.

Date() instead of Now() will return todays date.... though again... I would advice against it.

 

[bkuuz1]

Thanks for such a quick response.
I am ok with the date and time stamp entered together in the table as one unit but, I can't have the time stamp show up on the report.

Example. I have a form that my operators at a power plant will enter events that go on at the plant, the way that I have built the form is as follows,

Date - Time - Event code (drop down box) - Event.

The -Date, I want to populate auto-
The Time,- because of things going on the operator may not be able to enter the event when it immediately happens. So buy leaving my time box on the form tobe entered manually they can then enter the time for when the event happened and not for when they entered the log.

Also my other thought is, when the date and time would be sent to the report I could resize the box small enough so that only the date appears. If this is correct could you let me know. Thanks

 

[namliam]

=Date as default value in that case ...

If you want to trim off that date you can just change the format (is a property of any control) to only show the date or only show the time.