Lock a field after a certain 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.
 
J

John W. Vinson

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top