Hi all,
I'm putting together a timesheet database for a small company. There will be so far two types of users. 1, the boss and 2, the employees. There will be various forms also, such as 1, the timesheet 2, entering new employee 3, editing employee details etc
I was thinking, in order to keep employees entering their own hours only, I was going to have a password field for each employee. In the timesheet form, employees would have to enter their password and this would be checked with an IF statement (if possible) before an append query (into the hours/project tables) is executed.
Then I thought, that will not stop employees from going into the other "edit employees" forms from the switchboard.
So I thought a better idea would be to provide different access levels from the switchboard. The thing is, because of my lacking experience with access, I don't know if this is possible.
I was wondering what ideas you'd like to throw at me.
Thanks
I'm putting together a timesheet database for a small company. There will be so far two types of users. 1, the boss and 2, the employees. There will be various forms also, such as 1, the timesheet 2, entering new employee 3, editing employee details etc
I was thinking, in order to keep employees entering their own hours only, I was going to have a password field for each employee. In the timesheet form, employees would have to enter their password and this would be checked with an IF statement (if possible) before an append query (into the hours/project tables) is executed.
Then I thought, that will not stop employees from going into the other "edit employees" forms from the switchboard.
So I thought a better idea would be to provide different access levels from the switchboard. The thing is, because of my lacking experience with access, I don't know if this is possible.
I was wondering what ideas you'd like to throw at me.
Thanks
