Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding data in database and preventing changes

Status
Not open for further replies.

kingjjx

Programmer
Joined
Sep 18, 2001
Messages
181
Location
US
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
 
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.
 
"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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top