ValidationRule bug?

[Vladimír Cvajniga]

Question #1:
Due to internal rules I'm not allowed to set ValidationRule on database
level. On form level how do I tell Access not to leave a record if some
fields don't meet validation criteria? ValidationRule doesn't work as
expected and in some cases it is possible to leave a record even if
validation criteria don't match!!!

Question #2:
Is there any function in A2002 to check validation rules field by field,
record by record (on form's RecordsetClone level)? We had that function in
my beloved PC FAND...

TIA

Vlado

P.S. This is the second post. The first one didn't appear in the newsgroup
even after 30 minutes... :-/

 

[aaron.kempf]

Vlad

Microsoft censors posts; I woudn't worry about it

you should be using groups.google.com

 

[Ken Sheridan]

Vlado:

Your original post is there, at:

http://www.microsoft.com/office/com...&tid=7ef6344a-aae3-4c9d-8c42-9c44b3c447c2&p=1

Rick Brandt posted a reply.

Ken Sheridan
Stafford, England

 

[Vladimír Cvajniga]

Thx for the information, Ken.
————————————————————————————
This was Rick's respond to my post:
Do all such testing in the BeforeUpdate event of the form and set the Cancel
argument of that event to True when anything fails your tests.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
————————————————————————————

Thx for the information, Rick. IMO, it's quite a lot of coding. But I'll
have to do it anyway. :-(

Just an idea for next versions of Access: could that be done easier? Ie.
Form.MustMatchAllValidationCriteria property (True/False)... as we had in PC
FAND... ;-)

Vlado

 

[aaron.kempf]

what is PC Fand?

Thx for the information, Ken.
————————————————————————————
This was Rick's respond to my post:
Do all such testing in the BeforeUpdate event of the form and set the Cancel
argument of that event to True when anything fails your tests.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
————————————————————————————

Thx for the information, Rick. IMO, it's quite a lot of coding. But I'll
have to do it anyway. :-(

Just an idea for next versions of Access: could that be done easier? Ie.
Form.MustMatchAllValidationCriteria property (True/False)... as we had inPC
FAND... ;-)

Vlado

"Ken Sheridan" <[email protected]> píše v diskusním
příspěvku






- Show quoted text -