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

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/






More information about the AccessD mailing list