Mitsules, Mark
Mark.Mitsules at ngc.com
Wed Jul 16 14:50:55 CDT 2003
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 >>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 08:01 >>To: accessd at databaseadvisors.com >>Subject: Re: [AccessD] ValidationRule+ >> >>Ok...I'll side step... >>ValidationRules on Table=enforces when saves or when main form loses >>focus...not an option. ValidationRules on Form=enforces when changing >>field...not on save. >> >>Is there a way to force the Form ValidationRules via code? Maybe loop >>through all controls and validate? The problem is if I have a field >>with ValidationRules...and the user does not edit that field...the >>form validationRules are not enforced? >> >>Any ideas? >> >>Thanks, >> >>Mark A. Matte >> >> >> >From: "Borge Steen Hansen" <pcs at azizaz.com> >> >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 10:28:50 +1000 >> > >> >Mark, >> >I think this happens if the main form is a bound form.... when >> >moving into the subform, Access performs an automatic save of the >> >record and the validation rules that you have placed in the table >> >kick in. Regards Borge >> > >>_______________________________________________ >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com > >_________________________________________________________________ >MSN 8 with e-mail virus protection service: 2 months FREE* >http://join.msn.com/?page=features/virus > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com