I have a spreadsheet that gets it data from an external source. I have a
query setup that refreshed the data.

However, I need input from the user to say what month and year they want to
see. This works fine except for 2 things. Firstly when I run the query with
the query window open you get the window and it says whatever you called your
variable. I make the name something like "What Month", but when in normal use
(the query window is not open) the window doesnt display the variable name.
How can I get the input window to tell the user what it wants?

My second problem is that there is an OR statement in the query. This means
that although the variables input by the user stay the same, the user has to
put them in twice, once for each OR line in the query. I have given the two
lines the same variable names, but the system still asks twice. How can I
stop this from happening? I have a new sheet to produce and it will have 4 OR
statements meaning the input of the same information 4 times.

Check out "parameter_query" in the VBA help.

NickHK

"Keith" wrote in message
...
I have a spreadsheet that gets it data from an external source. I have a
query setup that refreshed the data.

However, I need input from the user to say what month and year they want
to
see. This works fine except for 2 things. Firstly when I run the query
with
the query window open you get the window and it says whatever you called
your
variable. I make the name something like "What Month", but when in normal
use
(the query window is not open) the window doesn't display the variable
name.
How can I get the input window to tell the user what it wants?

My second problem is that there is an OR statement in the query. This
means
that although the variables input by the user stay the same, the user has
to
put them in twice, once for each OR line in the query. I have given the
two
lines the same variable names, but the system still asks twice. How can I
stop this from happening? I have a new sheet to produce and it will have 4
OR
statements meaning the input of the same information 4 times.

Thanks for that Nick. I managed to solve the question about the variable
prompt, but can't seem to see anything refering to using the same variable
for all lines on an OR statement.

"NickHK" wrote:

Check out "parameter_query" in the VBA help.

NickHK

"Keith" wrote in message
...
I have a spreadsheet that gets it data from an external source. I have a
query setup that refreshed the data.

However, I need input from the user to say what month and year they want
to
see. This works fine except for 2 things. Firstly when I run the query
with
the query window open you get the window and it says whatever you called
your
variable. I make the name something like "What Month", but when in normal
use
(the query window is not open) the window doesn't display the variable
name.
How can I get the input window to tell the user what it wants?

My second problem is that there is an OR statement in the query. This
means
that although the variables input by the user stay the same, the user has
to
put them in twice, once for each OR line in the query. I have given the
two
lines the same variable names, but the system still asks twice. How can I
stop this from happening? I have a new sheet to produce and it will have 4
OR
statements meaning the input of the same information 4 times.

Keith,
If you can replace one instance, can't you replace them all ?
Not sure what the problem is.

NickHK

"Keith" wrote in message
...
Thanks for that Nick. I managed to solve the question about the variable
prompt, but can't seem to see anything refering to using the same variable
for all lines on an OR statement.

"NickHK" wrote:

Check out "parameter_query" in the VBA help.

NickHK

"Keith" wrote in message
...
I have a spreadsheet that gets it data from an external source. I have
a
query setup that refreshed the data.

However, I need input from the user to say what month and year they
want
to
see. This works fine except for 2 things. Firstly when I run the
query
with
the query window open you get the window and it says whatever you
called
your
variable. I make the name something like "What Month", but when in
normal
use
(the query window is not open) the window doesn't display the variable
name.
How can I get the input window to tell the user what it wants?

My second problem is that there is an OR statement in the query. This
means
that although the variables input by the user stay the same, the user
has
to
put them in twice, once for each OR line in the query. I have given
the
two
lines the same variable names, but the system still asks twice. How
can I
stop this from happening? I have a new sheet to produce and it will
have 4
OR
statements meaning the input of the same information 4 times.

Nick

It would appear that the SQL statement simply puts in a questionmark for all
the instances a variable is used, so if the user is asked for say the month
and there are three OR statements in the query is asks the question three
times.

I might be missing something obvious. I'm an Access programmer not Excel,
and there are differences to the code.

Any help would be great.

Keith

"NickHK" wrote:

Keith,
If you can replace one instance, can't you replace them all ?
Not sure what the problem is.

NickHK

"Keith" wrote in message
...
Thanks for that Nick. I managed to solve the question about the variable
prompt, but can't seem to see anything refering to using the same variable
for all lines on an OR statement.

"NickHK" wrote:

Check out "parameter_query" in the VBA help.

NickHK

"Keith" wrote in message
...
I have a spreadsheet that gets it data from an external source. I have
a
query setup that refreshed the data.

However, I need input from the user to say what month and year they
want
to
see. This works fine except for 2 things. Firstly when I run the
query
with
the query window open you get the window and it says whatever you
called
your
variable. I make the name something like "What Month", but when in
normal
use
(the query window is not open) the window doesn't display the variable
name.
How can I get the input window to tell the user what it wants?

My second problem is that there is an OR statement in the query. This
means
that although the variables input by the user stay the same, the user
has
to
put them in twice, once for each OR line in the query. I have given
the
two
lines the same variable names, but the system still asks twice. How
can I
stop this from happening? I have a new sheet to produce and it will
have 4
OR
statements meaning the input of the same information 4 times.

Keith,
What is your SQL statement ?

NickHK

"Keith" wrote in message
...
Nick

It would appear that the SQL statement simply puts in a questionmark for
all
the instances a variable is used, so if the user is asked for say the
month
and there are three OR statements in the query is asks the question three
times.

I might be missing something obvious. I'm an Access programmer not Excel,
and there are differences to the code.

Any help would be great.

Keith

"NickHK" wrote:

Keith,
If you can replace one instance, can't you replace them all ?
Not sure what the problem is.

NickHK

"Keith" wrote in message
...
Thanks for that Nick. I managed to solve the question about the
variable
prompt, but can't seem to see anything refering to using the same
variable
for all lines on an OR statement.

"NickHK" wrote:

Check out "parameter_query" in the VBA help.

NickHK

"Keith" wrote in message
...
I have a spreadsheet that gets it data from an external source. I
have
a
query setup that refreshed the data.

However, I need input from the user to say what month and year
they
want
to
see. This works fine except for 2 things. Firstly when I run the
query
with
the query window open you get the window and it says whatever you
called
your
variable. I make the name something like "What Month", but when in
normal
use
(the query window is not open) the window doesn't display the
variable
name.
How can I get the input window to tell the user what it wants?

My second problem is that there is an OR statement in the query.
This
means
that although the variables input by the user stay the same, the
user
has
to
put them in twice, once for each OR line in the query. I have
given
the
two
lines the same variable names, but the system still asks twice.
How
can I
stop this from happening? I have a new sheet to produce and it
will
have 4
OR
statements meaning the input of the same information 4 times.