Time Sheet Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form being used as a Time Sheet. Can I set up an ID # to be entered
so each person only has access to their name to enter a new time sheet.
Right now when the form is open all the employees names are on a drop down
list which you then choose your name from. Anyone can create a bogus time
sheet using another persons name. I have already set up a code # specific to
each person.
 
If you are using Access User-Level Security, then you can use their userid
to default this or force this entry to be their USERID. You couls also
limit queries, forms, and reports so they can only SEE their data.

To obtain their login id, simply use the following in your code, criteria,
or controls...

=CurrentUser()

You could force this value into a field before they save their form. Or
force it into a field when the form is opened, but make the field locked so
they can see it, but not shange it.

Of course, you will also have to lock them out of the tables so they can't
simply go around you.
 
Thanks for your reply, I have not set up user level security but what I want
is when they open form "Time Sheet" I want them to enter a code? and have
their name fill in for Employee Name. I don't want them typing it to make
sure it is entered the same every time. Is this possible?
 
What prevents them from simply opeing the table and writing over it?

Or going through the query?

I never recommend home-grown security. Make them sign on using User-Level
Security and define what they CAN and CAN'T do.
 
I have done this by using the Windows login userId. The user can only access
his schedule based on the login. I set up a table with there name and
windows login to only allow the person to see his own schedule/Timesheet.
You can get the windows login by

=Environ('UserName')

or go to

http://www.mvps.org/access/api/api0008.htm

Jim
 
Back
Top