[AccessD] ValidationRule+

Mark A Matte markamatte at hotmail.com
Wed Jul 16 09:44:06 CDT 2003


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



More information about the AccessD mailing list