Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - NotesHierarchical.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: NotesHierarchical.mdb
    Posted: 08 Jul 2008 at 10:24pm
This sample db demonstrates handling of performance notes in an organization. 
Persons in administrative position are assigned various levels. For example the top 
boss has level 1. Managers next in command, each have level 2. Supervisors next 
in command, each have level 3. General employees do not have any level 
assigned to them.
Though three level administrative set up is shown in the db, it can be adapted to 
any number of levels, simply by assigning levels 4, 5 & so on. In order to identify 
clear chain of command, the immediate boss for each employee is identified via 
BossID.  For top boss, BossID field is blank.
Performance notes for a given employee as selected, can be recorded at various 
levels by his superiors in direct chain of command. A person in senior position can 
not alter the notes recorded by those below him (but can view the same). The row 
source for combo box meant for selecting employee is set dynamically in such a 
manner that it is confined only to those in direct chain of command under the 
selected noter. This involves recursive reference to BossID field in employees 
table, implemented via user defined function.
Any person in administrative position, wishing to record a note, has to log in using a 
password. On successful log in, the noter has full read/write access to his own 
notes for the selected employee. At the same time, all the notes for this employee, 
as recorded by other noters (only those in the chain of command below the current 
noter) get displayed, but in read-only state.
The notes table, has a Yes/No field named Sent. When Sent is set to true, the 
note in question can no longer be edited, even by the person who recorded it 
originally. More-over, once set to True, it can no longer be re-set to False and no 
back dated note can be created. For example, if note dated 31-Dec-2006 for a 
given combination of employee and noter has been marked sent, and we are now 
in year 2007, any new note with date prior to 31-Dec-2006 can not be created this 
noter for the given employee.

Download Access 2K/XP/2K3/2K7: uploads/37/


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.