Adding data in database and preventing changes

[kingjjx]

Hi,How do you not enable a user to edit someting(data) that he has already submitted?
I have a page that looks something like this:

HOURS WORKED:
|MON|TUES|WED|
JANUARY | | | |
FEB | | | |
MARCH | | | |

Now, I want it that when a user has already submitted the info for his January work hours, when Febraury comes, and he enters his Febraury work hours, he can no longer change his January work hours and can still add his work hours for Feb.
All, this is in one table in Access.
Please help.

thank you

 

[tlhawkins]

hey Kingjjx

the way I did this was by putting a "Submit time" button that the user must use at the end of a pay period, then I have a field in the DB called "submitted" if time has allready been submitted then it can't be changed.

You could also make the same thing happen Automatically at the end of the month, or pay period, or whenever.

Hope it helps.

 

[Guest_imported]

"How do you not enable a user to edit someting ..." Do you mean "prevent a user from editing"? They can't edit anything unless you give them the ability. So, just don't let them.