Filter a form Trouble

[najah via AccessMonster.com]

First let me start by saying that I am not that experienced in this area. So
my explanation has to be explained to me as if I was a 2 year old!

I have created a database that tracks time for my company's employees based
on hours spent on a particular task and then calculates total bi weekly
hours. This enables us to run various time tracking reports.

In doing this, from the main switchboard, they will be able to enter their
hours for a particular pay period. They enter this info in a Mainform
(timesheet) which also contains a subform(timesheethours). The mainform
contains fields: [TimeSheetID],[EmployeeID], [StartDate],[EndDate], and
[DateEntered]. The subform has the detailed fields such as, [TaskID],
[TaskName],[Hours]. etc. Both these forms are based on underlying tables.
After entering data they ten run and print a report of their hours.

This database will be used in a multiuser environment, so I will split it
with the BE on the server and FE copies will be given to the individual
employees.

From the switchboard I allow the employees to view their certain timesheets
(reports) by entering start/end dates.

The problem.....
I need to also provide a switch from the switchboard that will allow these
employees to be able to go in and modify/edit their timesheets. I don't want
them to be able to view everyones info. When they click the button to
View/Edit timesheet, I only want them to have access to their own info. Only
the managers/supervisors will have access to all employee info. How do I do
this? Do I have to apply filters, if so I need step by step instuction on
doing so, especially if it involves VB and/or events. Please help be get
this monkey off of my back.

 

[Tim Ferguson]

I don't want
them to be able to view everyones info. When they click the button to
View/Edit timesheet, I only want them to have access to their own
info. Only the managers/supervisors will have access to all employee
info.

Straightforward answer:

If the employees will do what they are told, then you can base the forms on
suitable recordsets that will only show them the correct records:

SELECT * FROM Employees
WHERE EmployeeID = Forms!EmployeeDetails!EmployeeID

and so on.

Hope that helps

Tim F