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

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Fri Sep 5 09:48:39 CDT 2003


Must have missed that thread Arthur.  What are static functions?

Rocky

----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, September 05, 2003 8:36 AM
Subject: RE: [AccessD] A2K Reference the dot column property in a query


> Here I go with static functions again, Rocky :-)
>
> IMO it is insane to refer to forms in queries. It ties your hands and
makes
> your queries soooo un-reusable. You're on the right track with your public
> function but a static is way better, IMO. You can set it from anywhere,
> including the debug window, and check your query before running it in the
> real app world.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Thursday, September 04, 2003 8:51 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2K Reference the dot column property in a query
>
>
> I know there must be a solution to this problem but I've never figured it
> out.  Whenever I run into the problem of referencing a form value in a
query
> I always make a public function like:
>
> Public Function GetComboValue
>     GetComboValue=Forms!frmMyForm!cmbMyCombo.Column(2)
> End Function
>
> Then in the query you can put GetComboValue() and it will return the
value.
>
> Seems there should be a better way though.
>
> Rocky
>
> ----- Original Message -----
> From: "Darren DICK" <d.dick at uws.edu.au>
> To: "AccessD List" <AccessD at databaseadvisors.com>
> Sent: Thursday, September 04, 2003 8:34 PM
> Subject: [AccessD] A2K Reference the dot column property in a query
>
>
> > Hello all
> > In VBA the code to reference certain columns in a combo box on a form
> is...
> > Forms!frmMyForm!cmbMyCombo.Colum(2)  - Cool it all works
> > But when I use the same syntax in a query I get errors - namely
> > Undefined function '[Forms]!frmMyForm!cmbMyCombo.Column' in expression
> >
> > What should I type to reference a particular column of a combo in a
query?
> >
> > Many thanks in advance
> >
> > Darren
> >
> >
> > _______________________________________________
> > 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