[AccessD] ValidationRule+

Mark,

When I edit all the fields in the OnClose event, I have code to edit for
all the Business Rules.  The Validation Rules are a subset of the
Business Rules.  Once a record passes all the edits, all the validation
rules established for the fields have already been satisfied.  I do not
try to call the field validation properties during the editing process
since I use validation rules on table fields only as a precaution
against somebody getting direct access to the tables and trying to enter
dirty data.  In a nutshell, the validation rules that are on the fields
at the table level are duplicates of part of the business rules I check
in code.

I hope that clarifies things for you.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com] 
Sent: Wednesday 2003 Jul 16 14:34
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] ValidationRule+

I hate to sound desperate...but I am...Charles' solution sounds like it 
would work...but I'm not sure what is meant by 'where I edit all the
fields 
in the OnClose'.  I tried changing the value of the field via code...but

this did not envoke the ValidationRule.  Does anyone know how to test or

envoke the ValidationRules on a form?  My last resort is to check each 
control with an If statement and a msgbox.

Thanks Again,

Mark


>From: "Mark A Matte" <markamatte at hotmail.com>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] ValidationRule+
>Date: Wed, 16 Jul 2003 14:44:06 +0000
>
>Charles,
>'where I edit all the fields in the OnClose'
>
>What type of edit do you do?
>
>Thanks,
>
>Mark
>
>
>>From: "Wortz, Charles" <CWortz at tea.state.tx.us>
>>Reply-To: Access Developers discussion and problem
>>solving<accessd at databaseadvisors.com>
>>To: "Access Developers discussion and problem 
>>solving"<accessd at databaseadvisors.com>
>>Subject: RE: [AccessD] ValidationRule+
>>Date: Wed, 16 Jul 2003 08:31:17 -0500
>>
>>Mark,
>>
>>I have single-record forms where I edit all the fields in the OnClose 
>>event.  If all the edits are not passed, they cannot close the form 
>>and save the data.
>>
>>Charles Wortz