how can make an user interface

[ghost]

Hi,
I have a database for employee's tasks. It has 3 units. Each unit has a
supervisor. I will share the database on the LAN. What I want to do is making
a user interface. That means each supervisor can only see his employee. Can I
do that by using pages in MS access or any way? If you have any idea please
tell me.

 

[Arvin Meyer [MVP]]

The easiest way is to have a table of EmployeeID and SuperviorID. Join that
table to all your other queries which require the supervisor to only see his
employees. Use the function at:

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

to get the user's login name and use that function to create a public
function which can be used in the query to get those records belonging to
the Supervisor.

 

[Arvin Meyer [MVP]]

I've prepared a small sample database to illustrate how to do this:

http://www.accessmvp.com/Arvin/OnlyMyRecords.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[ghost]

where should i put the Module? at a form , page or where . please advice

 

[Arvin Meyer [MVP]]

It should be saved in a standard module.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com