Mark A Matte
markamatte at hotmail.com
Tue Jul 3 09:28:04 CDT 2007
No Prob...Just let me know. >From: "Joe Hecht" <jmhecht at earthlink.net> >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 >(Threeleveldesignquestion) >Date: Mon, 2 Jul 2007 19:09:17 -0700 > >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/ > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ http://liveearth.msn.com