...rules prohibited ...

[Guest]

Hello!

In Table, I would like to make a next "Validation Rule":

[Date1]>[Date2]

But return the next error message:
One or more values are prohibited by the validation... and don't save.
Why?

Thanks in advance.
an

 

[Rick Brandt]

Hello!

In Table, I would like to make a next "Validation Rule":

[Date1]>[Date2]

But return the next error message:
One or more values are prohibited by the validation... and don't save.
Why?

Thanks in advance.
an

You cannot refer to other fields in a *Field* validation rule. To do what you
want you need a *Table* validation rule. To create one of those you have to go
to the table property sheet while in design view. You will see property boxes
there for the table validation rule.

 

[Guest]

from Rainbow01 Hong Kong

from my experience, i never make Validation in Table

all Validation was made in Forms with using VBA may better

"an" 來函：

 

[Craig Alexander Morrison]

The major drawback with this approach is that any errant application can
break the validation rules for the database.

If you are using Jet as the backend you should try to use as many field and
table validations as you can as these will always be enforced against your
data.

If you are using DB2 (or SQL Server 2000) or any other Client Server RDBMS
then you have a vastly richer environment than field and table validation.

Application validation is also useful, however the fundamental rules should
be enforced at the database engine.

In the OPs case they would need to use a Table validation rule to compare
the values of two fields in the same table.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

from Rainbow01 Hong Kong

from my experience, i never make Validation in Table

all Validation was made in Forms with using VBA may better

"an" ??:

Hello!

In Table, I would like to make a next "Validation Rule":

[Date1]>[Date2]

But return the next error message:
One or more values are prohibited by the validation... and don't save.
Why?

Thanks in advance.
an

 

[Brendan Reynolds]

In addition to Rick's advice elsewhere in this thread, if either of the
fields can be Null, you'll need to allow for that in your validation rule
....

(Date1 > Date2) Or (Date1 Is Null) Or (Date2 Is Null)

 

[Guest]

Many thanks att all.
an

 

[Guest]

Thanks for your reply.

Is possible I don't understood but, before my post, I tried to aply that
Validation Rule - [Date1]>[Date2] - table property sheet. Return us that
error message (?)
an

Hello!

In Table, I would like to make a next "Validation Rule":

[Date1]>[Date2]

But return the next error message:
One or more values are prohibited by the validation... and don't save.
Why?

Thanks in advance.
an

You cannot refer to other fields in a *Field* validation rule. To do what you
want you need a *Table* validation rule. To create one of those you have to go
to the table property sheet while in design view. You will see property boxes
there for the table validation rule.