I need to set up 8 fields that use the same info ABCDEF or G, but I need to
have it dissallow an already used input. If field1 has a "B" then field2
options would be ACDEF or G. If field2 then has a "F" then field3 remaining
options would be ACDE or G.

I have to setup a database of all employees on my floor (about 100 people).  
This  tasks list will be for all new employees and current employees, when a
new employee is hired they need to fill out forms and then 6 months later to
an evaluation.  Then for all employees they need ...

What I want for a Validation Rule is...[CompleteDate]<=[BillDate]
And of course, I get the error message..."Invalid SQL syntax - cannot use
multiple columns in a column-level CHECK constraint."
I have code in my form to accomplish this same thing, but I have been

I have a table here that will store currency values. I've been reading up on
the differences between the datatypes available and there seem to be 2
viable candidates: Currency and Double.
Double can hold bigger/smaller numbers than currency, but suffers from the

My industry require results to be to a preciscion of 6 decimal places. Access
handles 1.012345 but returns 1. if there is no moderator ie result is
1.000000 displays 1.
How can you force Access / Excel to display the requisite number of decimal

Hi to all,
I work on an insurance project.I have a table,
tblPolicies, which has a triple primary key: BranchID,
CompanyID, PolicyN. To this table I want to relate another

hi
how i could know teh size of my tables ? also my forms

I'm creating a form and while going and back and forth I can no longer view
my form!

i am carrying out a research project for my class 1 and have to produce a
facilities management system capable of tracking resources, assets and
utilities. i was told that access would be a sufficient platform to achieve
my aim?

Can this be done.
I need to disallow duplicate records entered for a number field BUT allow
the number 0 to be duplicated
only 0

I know how I have my access application right now that isnt quite right, but
it works.  But I would like to know the proper way to do this.  I have 4
tables. Pension Fund Offices, Local Unions-pension & Medical Fund Offices,
Local Unions-medical.

I am in the design stage and wonder: I have a table that contains a name and
a "start date". An event is supposed to occur at regular intervals based on
that "start date. I know I can use calculated fields in a form or use a query
to figure the interval dates, but how do I get ...

There is some information regarding a disease for which the number of cases
and case rates are stored for each year and for all the counties in a state.
When designing a table for storing this information in Access, my table has
repeated values for the county names for each ...

I am new to Access-using Access 2002-am not familiar with VBA coding.
I have two "main" tables with a 1-to-1 relationship (couldn't fit all the
fields in one table-property value too large), and several lookup tables. I
created multitable forms from a query that contains both main ...

The command buttons, as it stands, go along with whatever the display theme
is in Windows.  How can the color be altered in Access 2000, or CAN it be
altered?