Adding Employee comments

[Jonnie]

I am in the process of building an employee database for use by the
management team here. They current have Access 97 (I am working on
getting them to upgrade to at least 2000). For the most part I have it
under control. There are several points that have popped up as wanted
features and I need to verify somethings.

1. We now want to add the ability to add comments/notes with time and
date stamps to an employees record. These comments will be permanent
and only removable by the database admin once added. We also want a
list of the comment subject to show in a subform, sorted by time/date
entered, when viewing a specific employee (this part seems pretty
simple). As well as stamping the user id logged into teh database
entering the notes. As far as the comments go, I have assumed the
following:

There will need to be a table for employee data and one for comments
(example below)

TABLE NAME: tblEmployees
TABLE FIELDS: Emp_ID, Comment_ID, Emp_FirstName, EmpLastName

TABLE NAME: tblComments
TABLE FIELDS: Comment_ID, Emp_ID, Comment_Notes, Comment_TimeSta mp

I am having difficulty with the relationships in this situation as
well. Is my thinking along the correct path?

2. Web based tool. I don't think this will be a huge deal once the
database itself is working as designed. Is there anything specifc
about multi-user access to the database that anyone is aware of?

3. Being able to pull data from other applications like BluePumpkin &
Avaya CenterVu from within the MS Access application. I have never
attempted this before, any information that you may have pointing me
in the right direction would be appreciated. I have linked to Excel
documents and other Access databases before with no problem.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Your tables should be like this:

tblEmployees
Emp_ID, Emp_FirstName, EmpLastName

tblComments
Comment_ID, Emp_ID, Comment_Notes, Comment_TimeSta mp

The relationship between both tables is a 1-to-many (tblEmployees [1],
tblComments [Many]) link thru the Emp_ID.

I'm not familiar with BluePumbkin and Avaya CenterVu. If they are
databases with ODBC drivers you can link to them as you'd link to any
ODBC data sources. If they are "something else" - find out if they
can be used as OLE servers & just open them that way - see the
GetObject and CreateObject methods in the Access Help file. You'll
also need to read any documentation the respective companies have on
their s/w's object models.

HTH,

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP/oOpoechKqOuFEgE QJR4ACg8rj3CcBM nZWSguDbRCw8e5a YmWQAoMwY
5y4pcFgzGXo/Z7+rynUgBfzB
=s1l5
-----END PGP SIGNATURE-----
Jonnie wrote:

I am in the process of building an employee database for use by the
management team here. They current have Access 97 (I am working on
getting them to upgrade to at least 2000). For the most part I have it
under control. There are several points that have popped up as wanted
features and I need to verify somethings.

1. We now want to add the ability to add comments/notes with time and
date stamps to an employees record. These comments will be permanent
and only removable by the database admin once added. We also want a
list of the comment subject to show in a subform, sorted by time/date
entered, when viewing a specific employee (this part seems pretty
simple). As well as stamping the user id logged into teh database
entering the notes. As far as the comments go, I have assumed the
following:

There will need to be a table for employee data and one for comments
(example below)

TABLE NAME: tblEmployees
TABLE FIELDS: Emp_ID, Comment_ID, Emp_FirstName, EmpLastName

TABLE NAME: tblComments
TABLE FIELDS: Comment_ID, Emp_ID, Comment_Notes, Comment_TimeSta mp

I am having difficulty with the relationships in this situation as
well. Is my thinking along the correct path?

2. Web based tool. I don't think this will be a huge deal once the
database itself is working as designed. Is there anything specifc
about multi-user access to the database that anyone is aware of?

3. Being able to pull data from other applications like BluePumpkin &
Avaya CenterVu from within the MS Access application. I have never
attempted this before, any information that you may have pointing me
in the right direction would be appreciated. I have linked to Excel
documents and other Access databases before with no problem.