Mark A Matte
markamatte at hotmail.com
Wed Jul 16 08:00:57 CDT 2003
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 > >----- Original Message ----- >From: "Mark A Matte" <markamatte at hotmail.com> >To: <accessd at databaseadvisors.com> >Sent: Wednesday, July 16, 2003 5:41 AM >Subject: RE: [AccessD] ValidationRule > > > > Charles, > > > > When I try to click on the subform...or one of its fields...the >validation > > rules of the main form's tables are enforced. > > > > Thanks, > > > > Mark > > > > Also, I tried to use the validation rules on the form instead of the > > table...but I don't know when they are inforced...whith all the rules on >the > > form...it lets me save no matter what.? > > > > > > > > >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: Tue, 15 Jul 2003 14:32:34 -0500 > > > > > >Mark, > > > > > >Are you saying that whenever you open the form that the subform is > > >displaying some data that does not conform to the validation rules you > > >have placed on those fields in the table? This should not happen if >the > > >subform is displaying existing data that is clean. However, if it is > > >showing a new record without proper default values already filled in, > > >then it will complain. > > > > > >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: Tuesday 2003 Jul 15 14:16 > > >To: accessd at databaseadvisors.com > > >Subject: [AccessD] ValidationRule > > > > > >Hello All, > > > > > >In A97 I have a form with a subform. I am using the Validation Rule in > > >the > > >tables to require certain fields. Everytime I try to go to the > > >subform...it > > >tries to enforce the ValidationRules. Is there a way to keep this from > > >happening until saving? > > > > > >Or a suggestion on how to require a field with out coding each one > > >individually on save? > > > > > >Thanks, > > > > > >Mark A. Matte > > >_______________________________________________ > > >AccessD mailing list > > >AccessD at databaseadvisors.com > > >http://databaseadvisors.com/mailman/listinfo/accessd > > >Website: http://www.databaseadvisors.com > > > > _________________________________________________________________ > > Protect your PC - get McAfee.com VirusScan Online > > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > > _______________________________________________ > > 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