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

Thanks for the explication, Stuart!

IMO the coolest thing about statics is that you can eliminate references to
forms. In the AfterUpdate event of some control, you call the static
function and pass the param. Anywhere else you need it, call the func
without a param. I don't like being tied to particular forms being open. I
want to be able to run a query etc. from the debug window anytime I want,
and to set said static func from the debug window anytime I want. Statics
give me this. That's why I love 'em.

A.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Saturday, September 06, 2003 8:23 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003