I am putting together a database to enter my reference library for program
and OS problems and solutions for same, and the updates that I have already
installed and what for.  These include answers and information I have
received from this and several other newsgroups and forums.

I need to design a database system that will allow employees to enter their work hours and the project number.  I also want to be able to query the employee info to build reports showing hrs worked on each project over a period of time. We have less than 20 employees & about 100 ...

I have to document an inherited set of MSAccess 2000 files and it would be
very helpful if I could customize the output from the tables documentor.  I
would like to have the table report output include the "field description"
(info visible in table design view) and the "caption" in ...

How do you get one field in a table to link to another
field? I have an IDNO field in a table that is entered
into the record by using a lookup from another table. I
am interested in having this lookup bring in more than

I have a number of responses to a survey question and
have been stumped on how to create a drop down list to
enter the data.The question is How long have you lived at
X?

Can anyone recommend a good Access book(s)?
I am a fairly advanced VB, VBA, SQL Server developer and did some Access
projects a few years ago.  Just got a new assignment and am looking for some
advanced Access books.

I cannot form relationships with my tables.  I keep getting indeterminate realtionships.  I believe this is becasue I cannot define a primary key.  I want to use three fields to define my primary key; however, I continue to get an error message that there are duplicates or the ...

I have developed an Access database for my company which has used it since
more than a year.
Till now, nothing big has changed in the table design. Only for the forms
and queries which get changed as I'm learning new methods of programming.

I am working with a table that was created
programmatically.  The name of the PRIMARY KEY was
automatically generated by Access.  How can I find out
what the PRIMARY KEY name is?

Hello:  In table design you can use the lookup wizard to
provide a list of possible values for a field that's
obtained from another table.  Is it possible to further
limit the values in the lookup list, based on the value of

Can anyone point me to an article that shows how I can display a day of the
week from a date. I've got one field in a table that has a date and want to
show the day in an attendance register.
Comments appreciated

I have 3 tables - employees, performance evals, and error codes.  The error codes is more of a look-up table that is indexed by a unique number.  The performance eval table will contain the unique employee id and then the error code(s) for a given date.  It is possible that an ...

I have created a table with a hyperlink field.  The
hyperlink is used to open files stored in a "shared"
folder on the network server.  The database is stored in
the same shared folder.  

I have 3 databases, one for Customer relationship management, on
containing detailed product information (will be quite large...) an
one for processing orders.
All three need to be linked.