I am searching for a better way to keep track of employee payroll and
statistics.  I understand the concepts of DB design pretty well, building
tables and queries, normalization, etc.  However, I have a vision of how I
would like this to work but I have no idea how to go about it ...

My database consists of 3 tables. All of them have Primary keys. They are
linked but will not relate with referential integrity no matter what I do. I
always get a message about not being able to enter new date into the "child"
tables when I try to relate them. I have tried ...

I have an orders and an order details table with a one to many relationship
based on a work order ID.  I also have a location information table that
includes addresses; the location name is the primary key in this table. The
Order details table lists the A location and Z location ...

I have created a database to use for my invoicing. The date field always
changes on past records to the current date. How can I set it to hold the
date on each record that it was created on and not the current date?

I am creating a database of names and telephone numbers etc. for my work and
I can't seem to get one of my Validation rules to work. I am basically trying
to make the database so that it is fool-proof. So in doing this I am trying
to create a validation rule that prevents the ...

I don't want to show the database anytime.  I had uncheck the Display
Database Window and the Use access special Keys.  But when I print a form
using an event procedure On Click, the database shows.
The procedure is the one used for the command print a form.

I have a dbase with Case, Citation, Court, Summary, and some other fields.  I
also have a table of topics (categories for cross references).  I want to be
able to select any, and all, categories that may apply to a particular case.  
For instance, Alexander v. F.B.I. can fall into ...

I am making some modifications to an existing MS Access Application and need
to add a new column (field) to a table in the database.  Since the table is
linked to other tables, I get a message saying "Can't save property changes
for linked tables".  I was under the impression ...

I know that the DB design is one of the most important steps in creating a
project, that is why I am asking for your help.  I am novice at using Access,
but I do have programming experience, mainly from COBOL.  
My new project.  I am looking at creating a DB to track a sporting ...

I have 3 tables: People, Projects, People\Projects.
Table People\Projects kepts track of the people assigned to a project. How
can I keep a person from being assigned to a project twice.

When setting a format to "Percent" in the table defination any amount input
is multiplied by 100 and a "%" symbol is added.  e.g. If I enter 5.5 in the
field the field will display 550%.  I would like to enter the amount in the
field as the actual percent amont 5.5% and have the ...

i own a small resort and am looking for assistance in making the reservation
database easier to handle.
i am using access XP. anyone know of an easy way to set up a nightly/weekly
database? we currently enter in each day the person is staying, and using

I have a yes/no check box field.  If the value = yes I would like to change
the color of that particular row.  Is there a way to accomplish this?
Thank you.

I'm using Access 97. I have created a unique key including one text field.
When I add a record with 'a' as this field's value I get an error message
because of a duplicate value in the index. I already have a record with a
capital 'A' which I have figured out to be the reason for ...

My application is deployed as a front-end / back-end Access 2000 application
(on any Windows platforms using Win98 or higher) and is optionally packaged
/ distributed with Access 2000 Runtime (the CD version has the runtime
library --- the download version does not).