Must Fill in a Field

[Aurora]

I am using Access 2003
I have a form that is used to check out equipment. The equipment is
numbered. When an employee want to check out a piece of equipment he locates
the equipment number, Checks the box to indicate that he has the equipment
(true/false field) and is suppose to enter his employee ID in the ID field.
If I make the ID field mandatory in the table, then on another form (used to
enter equipement data) that also contains this same true/false field can't be
saved. Is there a formula I could put in the query that says "if box field
is checked, then you must enter ID". If box is not checked then ID can be
null. I would certainly appreciate any help you can give me.

thank you - aurora

 

[Mr B]

From the way you described the actions being taken, I get the idea that the
employee may not be a his or her computer when this action is being taken,
but rather more that one of the employees may be using the same computer to
specify that they have a piece of equipment.

So, my first question would be is the situation that I above the case or
does each individual have their own computer (work station)?

Depending on the situation, there are ways to get the results you are wanting.

I know that this does not answer the 'How to" part of your question but
there are some things that would make a big difference as to how or what you
need to do.

How many employees are subject to use this database in the way you describe?

Do you also need to verify that the Employee ID is a valid employee ID?

Please post back we will try to help.

 

[Allen Browne]

Please do not post multiple copies of the same question to different groups.

 

[Aurora]

There are 15 employee who use this database. No they do not all have their
own computer. What I want is to block the Db screen from being saved until
the employee has entered his ID number. Maybe a prompt that says "enter your
Id number before saving". Right now the ID field is a pull down menu with
all of the ID #'s listed. All the employee has to do is to click on his ID
number. But they do not remember to do this. Is this possible?

Aurora

 

[Rick Brandt]

There are 15 employee who use this database. No they do not all have their
own computer. What I want is to block the Db screen from being saved until
the employee has entered his ID number. Maybe a prompt that says "enter your
Id number before saving". Right now the ID field is a pull down menu with
all of the ID #'s listed. All the employee has to do is to click on his ID
number. But they do not remember to do this. Is this possible?

If you make that field "Required = Yes" in the table's design then it will be
impossible to save a record unless that value is filled in. For a more
user-friendly message you can make "Required = No" but add a Validation Rule of
"Is Not Null" on that field. The Validation Text property lets you specify what
the message is when the rule is violated.