[AccessD] FW: Basic Question

Instead of "[Event Procedure]" or "MacroName", put "=myFunction()" in the 
property box.

On 24 Feb 2007 at 3:03, Mark A Matte wrote:

> 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=T001MSN
> >20A0701
> >
> 
> 
> >--
> >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.a
> spx?icid=HMFebtagline
> 
> 

-- 
Stuart