[AccessD] A2K Reference the dot column property in a query

Oh.  That's very cool.

Rocky

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, September 05, 2003 5:40 PM
Subject: Re: [AccessD] A2K Reference the dot column property in a query


> On 5 Sep 2003 at 7:48, Rocky Smolin - Beach Access S wrote:
>
> > Must have missed that thread Arthur.  What are static functions?
> >
>
>
> Functions which retain the value of their variables between calls.
> Something like:
>
> STATIC FUNCTION StartDate(OPTIONAL dteStartDate as Date) as Date
> Local dteStore as Date
> IF NOT ISNULLl(dteStartDate) Then
>      dteStore = dteStartDate
> END IF
> StartDate = dteStore
> End FUNCTION
>
> Every time you call the function with a date parameter, it sets its
> value. Every time you call it without a parameter, it returns the
> last value set.
>
> You can now  you user select a start date on a "pick form" somewhere.
> When they have picked it, set the value of  Startdate() with
> something like dteTemp = StartDate(txtStartDate)
>
> Now you can use "=StartDate()" in reports, queries, form filters etc
> anywhere you like. It will return the selected value  until the user
> goes back to the pick form and changes it.
>
>
>
> -- 
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>