[AccessD] FW: Basic Question

How do you put a set the BeforeUpdate to a function...I thought you
could either pick [Event Procedure] or the name of a macro?

Thanks,

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] FW: Basic Question
>Date: Thu, 22 Feb 2007 18:10:39 +0000
>
>How do you put a set the BeforeUpdate to a function...I thought you could 
>either pick [Event Procedure] or the name of a macro?
>
>Thanks,
>
>Mark
>
>
>>From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
>>Reply-To: Access Developers discussion and problem 
>>solving<accessd at databaseadvisors.com>
>>To: <accessd at databaseadvisors.com>
>>Subject: [AccessD] FW: Basic Question
>>Date: Thu, 22 Feb 2007 10:02:01 -0800
>>
>>FYI - Here's the workaround he came up with
>>
>>Rocky
>>
>>
>>   _____
>>
>>From: Mike Dwyer [mailto:mike at aesadvantage.net]
>>Sent: Thursday, February 22, 2007 9:58 AM
>>To: Rocky Smolin; bheygood at abestsystems.com; Dixon; Barry Hynum;
>>Bob_Heygood; Doug Murphy; Ed Lance; Jackie Murphy; JKA Joe K Anderson
>>Subject: RE: Basic Question
>>
>>
>>
>>Thanks, Rocky.
>>
>>My workaround seems to be nice and simple:  I selected all 120 fields and 
>>in
>>the Property Sheet I entered: "BeforeUpdate() = True" in the 
>>ValidationRule
>>property.  This will call the function and if it returns False, the
>>validation rule will fail.  Within the function I set the ValidationText 
>>to
>>my error message and it works just fine.
>>
>>
>>
>>
>>
>>--
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>
>_________________________________________________________________
>Find what you need at prices you’ll love. Compare products and save at MSN® 
>Shopping. 
>http://shopping.msn.com/default/shp/?ptnrid=37,ptnrdata=24102&tcode=T001MSN20A0701
>


>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
With tax season right around the corner, make sure to follow these few 
simple tips. 
http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.aspx?icid=HMFebtagline