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

John Colby jcolby at colbyconsulting.com
Sat Sep 6 20:16:41 CDT 2003


Given that it's static, you have to have one of these functions for each
param (each query) correct?

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller
Sent: Saturday, September 06, 2003 11:20 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] A2K Reference the dot column property in a query


I suppose I could save them to a table, but so far I don't bother. My
biggest concern is run-time evaluation, not preservation between runs. I
developed this technique because I needed to "remember" a bunch of variables
that are all set on different forms, and then use them elsewhere. To take a
trivial example, if you select "Bruce Springsteen in Toronto", that must act
as a filter on several other forms, which may or may not be open at the time
you select. (Given that I rely heavily on JC's JIT tabs, said forms are
often but not always not yet loaded.) Gradually this led me to a system in
which I don't rely on any forms being open. Instead I call the statics in
SET mode when the user selects something of interest, and then call them
again in GET mode when I need them.

Typically I call them in SET mode in an AfterUpdate of some control on some
page or other. Occasionally it's in the OnCurrent method of a form. I just
did one like that today, where there's an unbound form containing a
datasheet subform, and on the master form's footer is a button for Delete.
The subform's OnCurrent calls CurrentTicketAllocationID() and passes the PK
to it. The button interrogates CurrentTicketAllocationID() without a param
and obtains the just-set value, then passes it to a sproc that does a sort
of cascade-delete but with smarts. It's one line of code to set it and one
line of code to get it.

HTH,
Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Michael R
Mattys
Sent: Saturday, September 06, 2003 11:23 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2K Reference the dot column property in a query


Arthur,

Where and when are you initializing these
static variables? Do you write them to a
table on the close of your database and
retrieve them at the opening?
(Like a registry hive)

Michael R. Mattys
www.mattysconsulting.com



----- Original Message -----
From: "Arthur Fuller" <artful at rogers.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, September 06, 2003 2:48 PM
Subject: RE: [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
>
> _______________________________________________
> 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

_______________________________________________
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