Input Date for Data Entry Operator

[bostonfrog]

I would like to add a calculated control on my form that would show the date on which a new record was created by data entry personnel. I know that there are date functions (e.g., Date), but I want the control to "hard code" the entry date for the new record, and not change because the computer's system date is tomorrow or whenever in the future. Any suggestions? Thanks.

 

[BillPower]

In the InputDate field in the table make:

Data Type Date/Time
Format Short Date
Default Value =Date()

It's up to you whether or not to display the field on your form, but if you do, Disable and Lock the Control.

Bill

 

[BillPower]

My post should read:

Data Type Date/Time
Format Short Date
Default Value =Date()

Bill

 

[bostonfrog]

Thanks for the prompt advice, Bill, but won't that date change every day the database is opened!? If I add the InputDate field, won't it just display today's date for every other record that was already processed? The input date for previously-entered records needs to stay the same, and not change because the system clock is different. Thanks.
-- Michel

 

[BillPower]

Hi bostonfrog,

Why don't you try it first.

However a record is entered into this table using the advice above, directly into the table, a query, a recordset, a form. Whatever date the record is entered will be recorded and remain in the InputDate field. The only way the date could change is if you write a procedure to change it or change it manually. I don't know what more I can say.

Bill

 

[BillPower]

Hi bostonfrog,

How did you get on with this? Would be nice to know.

Bill

 

[bostonfrog]

Bill, thanks for asking. So far using the Date() function within the table works fine. I had almost forgotten that you can build criteria within a table, not just in queries or forms.
-- Michel