Re: query variable

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tom Ellison (tellison_at_jcdoyle.com)
Date: 03/28/04 

Date: Sun, 28 Mar 2004 08:33:37 -0600

Dear Ludovic:

Instead of referencing the variable by name, which isn't going to
work, reference a public function (which you must write) that simply
returns the current value of the variable.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

On Sun, 28 Mar 2004 21:52:16 +0800, "Vsn" <vba@hotmail.com> wrote:

>Hello experts,
>
>Could some one tell me how I can feed a value in a variable that I put in a
>query criterea like <[x] before the box asking for this value pops up?
>
>SELECT tblUnits.MarineID
>from tblUnits
>WHERE (((tblUnits.MarineID)>[x]))
>WITH OWNERACCESS OPTION;
>
>And besides this is it possible to refere to a variable declared in a
>module?
>
>Thanks for the help.
>
>Ludovic
>

Relevant Pages

  • Re: Query Criteria
    ... I was referencing the label instead of the combo box, ... Tom Ellison wrote: ... value in that combo box so there is something on which the query can ...
    (microsoft.public.access.queries)
  • Re: query variable
    ... > Instead of referencing the variable by name, ... > Tom Ellison ... > Ellison Enterprises - Your One Stop IT Experts ... >>from tblUnits ...
    (microsoft.public.access.queries)
  • Re: Reassigning variable to new object destroys old one?
    ... When you assign the second instance to $x, ... referencing the first instance. ... public function __construct ...
    (comp.lang.php)
  • Re: Array Function
    ... You're referencing "FieldArray" in your function, and for the life of me, I ... > Public Function FieldArrayas arraylist ... > Private Sub Page_Load(ByVal sender As System.Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Reassigning variable to new object destroys old one?
    ... When you assign the second instance to $x, ... referencing the first instance. ... public function __construct ...
    (comp.lang.php)