[AccessD] Function vs Sub (was: Classes andEvents- EVENTSNOTREQUIRED)

William Hindman wdhindman at dejpolsystems.com
Wed Feb 25 10:24:00 CST 2009


...two gurus jousting ...and I get to learn from both! ...almost as good as 
a ringside seat at a jc rant!

William

--------------------------------------------------
From: "Charlotte Foust" <cfoust at infostatsystems.com>
Sent: Wednesday, February 25, 2009 11:08 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Function vs Sub (was: Classes andEvents-EVENTSNOTREQUIRED)> No it doesn't, it's setting a property of the event.  That isn't the
> same thing as returning a value as does a function.  Subs are quite
> capable of setting values or they wouldn't be as useful as they are.
> They do NOT return a value directly however.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Tuesday, February 24, 2009 11:56 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Function vs Sub (was: Classes and Events-
> EVENTSNOTREQUIRED)
>
> Hi Charlotte
>
> Eh, you can't have forgotten that setting Cancel to True in your code of
> such a sub will return that value to the form?
>
> /gustav
>
>
>>>> cfoust at infostatsystems.com 24-02-2009 22:21 >>>
> Not sure I follow, Stuart.  Subs set values like Cancel or process a
> keycode.  They don't return them per se.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan
> Sent: Tuesday, February 24, 2009 1:12 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Function vs Sub (was: Classes and Events -
> EVENTSNOTREQUIRED)
>
> Which begs the question, why does VBA use Subs for event procedures
> which return values such as Cancel or KeyCode?  Aren't these Functions?
> :-)
>
> --
> Stuart
>
>
> On 24 Feb 2009 at 9:24, Charlotte Foust wrote:
>
>> Absolutely when you need multiple return values, but a simple boolean
>> or single value?
>>
>> Charlotte Foust
>
>
>
> -- 
> 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
> 




More information about the AccessD mailing list