[AccessD] Function vs Sub

Max Wanadoo max.wanadoo at gmail.com
Wed Feb 25 14:41:03 CST 2009


Ha!  I bet he resembles that remark

Max
Laugh more than cry.  Smile more than frown.  Be generous in  spirit.  And
always stand your round in the pub!



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 25 February 2009 19:28
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Function vs Sub

Serpintly not, John.  I admire you tremendously, especially the way you
change colors as your blood pressure shoots up.  Beats sunset watching
hands down!  LOL

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, February 25, 2009 11:20 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Function vs Sub

Hmmm... I think I have just been dissed.  It's pretty bad when you
aren't even sure if you have been dissed.

;)

John W. Colby
www.ColbyConsulting.com


Charlotte Foust wrote:
> What, precision?  I've been studying JC and learning his approach.  
> ;->
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Wednesday, February 25, 2009 10:51 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Function vs Sub (was: Classes and Events - 
> EVENTSNOT REQUIRED)
> 
>>> Sorry for not being precise
> 
> Won't get you far on this List, Charlotte!
> 
> Max
> Laugh more than cry.  Smile more than frown.  Be generous in  spirit.
> And always stand your round in the pub!
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav 
> Brock
> Sent: 25 February 2009 16:37
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Function vs Sub (was: Classes and Events - 
> EVENTS NOT
> REQUIRED)
> 
> Hi Charlotte
> 
> OK, I see what you mean. I was talking about the value of that
property.
> Sorry for not being precise.
> 
> /gustav
> 
>>>> cfoust at infostatsystems.com 25-02-2009 17:08 >>>
> 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
> 
--
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