[AccessD] ValidationRule+desperate

Mark,

I chose the word "edit" carefully so no one should misunderstand that
all I do is check the validation rules that are implemented at the field
level.  Many of the business rules are too complex to do at the field
level, such as "If field A has a value from set X, then field B must
have a value from set Y," where sets X and Y may have anything from very
simple to very complex relationships.

See my comments under the other thread on this topic that the other Mark
has created.

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: Mitsules, Mark [mailto:Mark.Mitsules at ngc.com] 
Sent: Wednesday 2003 Jul 16 14:51
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] ValidationRule+desperate

Mark,

If I understand this conversation correctly, what Charles is saying is
that he DOES check each control against their corresponding validation
rules. I'm guessing that his statement 'where I edit all the fields in
the OnClose' possibly should have read 'where I _validate_ all the
fields in the OnClose'.  But based on your "Last resort", I think you
are on the right track.


Mark


-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com] 
Sent: Wednesday, July 16, 2003 3:35 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] ValidationRule+desperate


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