Mark A Matte
markamatte at hotmail.com
Wed Jul 16 14:34:24 CDT 2003
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 _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com