[AccessD] Never Take a job for a friend (Three level designquestion)

Joe:

I've got a simple schemeto control access levels.  I can handle it with you
off line.  But I'm out of town right now. Won't be back until next Sunday. 
Can it wait?

Anyone who knows access can defeat this scheme but in an environment where
people are behaving this works well.

Here's the basic steps:

1. Create a User table - Autonumber, User Name, Password, Accesss Level.
2. Create a global variable gintAccessLevel
3. On the opening form load the names and passwords into a combo box. 
Prompt for user name and password.
4. Store user's access level in gintAccessLevel.
5. On each form oreach function where you want to restrict access check the
user access level and bail if the level's not correct. 


HTH 

ROcky

Original Message:
-----------------
From: Joe Hecht jmhecht at earthlink.net
Date: Sat, 30 Jun 2007 16:08:12 -0700
To: accessd at databaseadvisors.com
Subject: [AccessD] Never Take a job for a friend (Three level
designquestion)


It is simple. Ya Right

 

I am righting a poor mans HR program. There are four user levels.
Dispatchers can not do notes, can not see notes. Field supervisor can write
notes. Can not see manager or executive notes.  Managers can write notes,
can read Field supervisor notes, not edit them or see executive notes.
Executives can write theirs, see but not edit all other notes.

 

Notes are many notes to one employee. 

 

How do I do notes so people see them in chronological order? If I do three
sub tables how would I get all notes to same point. One employee can have
multiple incidents good and bad in their record. How would I get all three
levels of notes to same incident?

 

Ya all know where I am spending my sat night.

 

 

 

Joe Hecht

jmhecht at earthlink.net

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--------------------------------------------------------------------
mail2web - Check your email from the web at
http://link.mail2web.com/mail2web