Lock a field after a certain date

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

I have an employee attendance calendar where employees will enter vacation
days for a given month/year.

I am using Access 2003 and I have what I think is a simple question.

My users can edit or delete dates. I want to continue this BUT I want to
make sure they can't change a past date. IE if they were scheduled to take
off 1/12/10 up to 1/12 they can make changes, however on 1/13 the field will
be locked and only the administrator can make the change.

Any help appreciated.
 
I have an employee attendance calendar where employees will enter vacation
days for a given month/year.

I am using Access 2003 and I have what I think is a simple question.

My users can edit or delete dates. I want to continue this BUT I want to
make sure they can't change a past date. IE if they were scheduled to take
off 1/12/10 up to 1/12 they can make changes, however on 1/13 the field will
be locked and only the administrator can make the change.

Any help appreciated.
Click to expand...

You can use Conditional Formatting on the form to disable the date textbox if
it contains a date prior to today's date. Open the form in design view; select
the textbox; choose "Conditional Formatting" from the Format menu item on the
toolbar (not the format property of the textbox itself).

Put a condition of < Date() on the condition row, and select the greyed-out
item.
 
Back
Top