Joe Hecht
jmhecht at earthlink.net
Mon Jul 2 21:09:17 CDT 2007
Mark, I may want to steal ( I mean borrow )after I see the network setup next week. Joe Hecht jmhecht at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Monday, July 02, 2007 8:51 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Never Take a job for a friend (Three leveldesignquestion) Joe, I have a db that allows multiple people can add notes. No One can edit old notes. Each note has a DT stamp,User_ID, and note type. The notes are added via an unbound box. If I wanted to impliment what you described...I would probably add a field to my notes table...and along with DTS and USER...I would add a User_Type to the notes. Dispatchers =D Field supervisor =F manager =M executive notes=E Each time a note is created the User_Type would be populated with one of the above depending on the users level of access. One the form/subform displaying the notes...I would change the data source via VBA(depending on user), the 'where' clause specifically. If a dispatcher is logged in..."where User_Type ='D'"...since Dispatchers cannot add notes...none would be returned. See below: EXAMPLE WHERE CLAUSES Dispatchers =where User_Type ='D' Field supervisor =where User_Type ='D' or User_Type ='F' manager =where User_Type ='D' or User_Type ='F' or User_Type ='M' executive notes=where User_Type ='D' or User_Type ='F' or User_Type ='M' or User_Type='E' Just a thought... Good Luck, Mark A. Matte >From: "Arthur Fuller" <fuller.artful at gmail.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] Never Take a job for a friend (Three level >designquestion) >Date: Sun, 1 Jul 2007 13:07:49 -0400 > >Minor addendum, perhaps obvious. If a dispatcher is looking, hide the >Notes, >period. > >Arthur > > >On 7/1/07, Arthur Fuller <fuller.artful at gmail.com> wrote: > > > > I think that some of the respondents so far kind of missed your > > requirements, Joe (or perhaps the beer I'm enjoying for Canada has had >more > > effect than I anticipated). > > > > You actually have only 3 meaningful user levels, since dispatchers are > > powerless. The other three make a grid like this: > > > > Sup Mgr Exec > > Sup W X X > > Mgr R W X > > Exec R R W > > > > Where R means Read, W means Write, and X means neither. If the user >table > > contained a 3-char column with each horizontal combination written as a > > string (i.e. WXX, RWX and RRW) then the OnCurrent event can examine the > > current row's notes field and act accordingly. > > > > This demands of course that the Notes rows be tagged with UserLevel >column > > (S, M or E). > > > > If a Sup is looking and the current Notes.UserLevel column contains M or > > E, hide the Notes. > > If a Mgr is looking and the current Notes UserLevel contains S, then > > Notes.enabled = False; if the Notes UserLevel is E, then hide the Note. > > If an Exec is looking, and the current Notes UserLevl contains S or M, > > Notes.enabled = False, else Notes.Enabled = True. > > > > I think that covers it. > > > > hth, > > Arthur > > > > > > This problem will be much easier to deal with if the notes are presented > > in single-form fashion rather than datasheet. That said, > > > > > > On 6/30/07, Joe Hecht <jmhecht at earthlink.net> wrote: > > > > > > 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 > > > > > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Dont miss your chance to WIN $10,000 and other great prizes from Microsoft Office Live http://clk.atdmt.com/MRT/go/aub0540003042mrt/direct/01/