how can make an user interface

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

Guest

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.
 
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.
 
Back
Top