query variable

  • Thread starter Thread starter Vsn
  • Start date Start date
V

Vsn

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
 
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
 
Tom,

Will try this and let you know if I did manage to do so.

Thanks,
Ludovic

Tom Ellison said:
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


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
Click to expand...
Click to expand...
 
Tom,

I have been quite bussy with other matters, sorry it took so long to send
you a response.

I have followed your directions and created a couple of functions and all
works fine, thanks for the help.

Ludovic

Vsn said:
Tom,

Will try this and let you know if I did manage to do so.

Thanks,
Ludovic

Tom Ellison said:
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top