Validate a Range of Cells

Hi,

I want to stop a user from being able to put a number twice in a column of cells. For exemple I don't want column A from row 5 to 60 to contain the same number.


Thank You in advance
CTInt04

Hi
see:
http://www.cpearson.com/excel/NoDupEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany


CTInt04 wrote:
Hi,

I want to stop a user from being able to put a number twice in a
column of cells. For exemple I don't want column A from row 5 to 60
to contain the same number.


Thank You in advance
CTInt04

Hi CTInt04,

Validate or restrict data entry in tables (MDB)
Note The information in this topic applies only to a Microsoft Access
database (.mdb).

A field validation rule is used to check the value entered into a field as
the user leaves the field. A record validation rule controls when an entire
record can be saved. Unlike field validation rules, record validation rules
can refer to other fields.

You can also determine whether data that already existed before you
specified a validation rule or changed the Required or AllowZeroLength
property violates the current settings.

Open a table in Design view (Design view: A window that shows the design of
these database objects: tables, queries, forms, reports, macros, and data
access pages. In Design view, you can create new database objects and
modify the design of existing ones.).

Define a validation rule to control when a record can be saved
-------------------------------------------------------------------
Click Properties on the toolbar to display the table's property sheet.
In the ValidationRule property box, type the validation rule. Or click the
Build button to create the validation rule using the Expression Builder
(Expression Builder: An Access tool that you can use to create an
expression. It includes a list of common expressions that you can select.).
For example, you could define the validation expression
"[RequiredDate]=[OrderDate]+30" to make sure that the date entered into
the RequiredDate field is within 30 days of the date in the OrderDate field.

In the ValidationText property box, type the message that you want
Microsoft Access to display when the rule is broken.
For example, for the validation expression
"[RequiredDate]=[OrderDate]+30", you could enter "The required date must
be within 30 days of the order date."

If you set a validation rule in a table that contains data, Microsoft
Access will ask if you want to apply the new rule to existing data when you
save the table. If you click Yes, Microsoft Access will warn you when
existing data violates the validation rule.

http://office.microsoft.com/assistan...051884281033&C
TT=1&Origin=EC790000701033&QueryID=6cp517yd50&Quer y=Validate+or+restrict+dat
a+entry+in+tables+(MDB)&Scope=TC%2cHP%2cHA%2cRC%2c FX%2cES%2cEP%2cDC%2cXT

Validation rules allow you to define a rule to limit what will be accepted.
They are enforced whenever you add or edit data, whether it is through
table Datasheet view (Datasheet view: A window that displays data from a
table, form, query, view, or stored procedure in a row-and-column format.
In Datasheet view, you can edit fields, add and delete data, and search for
data.), a form bound to the table, an append query (append query: An action
query that adds the records in a query's result set to the end of an
existing table.), an update query (update query: An action query (SQL
statement) that changes a set of records according to criteria (search
conditions) that you specify.), Visual Basic for Applications code, or by
importing data from another table. You can define two kinds of validation
rules: field validation rules and record validation rules.

A field validation rule is used to check the value entered into a field as
the user leaves the field. For example, you could define "=10 And =100"
as the validation rule for a Number field to allow only values from 10 to
100 to be entered.
A record validation rule controls when an entire record can be saved.
Unlike field validation rules, record validation rules can refer to other
fields in the same table. This makes them useful when you want to compare
values in different fields. For example, you could define
"[RequiredDate]=[OrderDate]+30" as the validation rule for an Orders
table. This rule would make sure that the date entered into the
RequiredDate field is within 30 days of the date in the OrderDate field.
When a field or record validation rule is broken, Access displays a message
that informs the user how to properly enter data.

http://office.microsoft.com/assistan...052623481033&C
TT=1&Origin=EC790000701033&QueryID=6cp517yd50&Quer y=Validate+or+restrict+dat
a+entry+in+tables+(MDB)&Scope=TC%2cHP%2cHA%2cRC%2c FX%2cES%2cEP%2cDC%2cXT

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.