Query Parameters

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a template that contains a query and macros/modules
behind it that I use daily. When I first created the
query that contains parameters I could see what column the
parameter was looking for, however, all of the sudden I
can no longer see the column. I still get the box to
enter the parameter, but if I forget the order then of
course the query doesn't work correctly. How can I get
this back. I tried creating a new one, by copying and
pasting, but that didn't work. I really don't want to
create a new query because this one took so much time.

Thanks for any help in advance.
Jeff
 
Jeff
I have a template that contains a query and macros/modules
behind it that I use daily. When I first created the
query that contains parameters I could see what column the
parameter was looking for, however, all of the sudden I
can no longer see the column.
Click to expand...

Do you mean Excel highlighted the column to which the parameter would apply?
I've never seen that. What version of Excel are you using?
I still get the box to
enter the parameter, but if I forget the order then of
course the query doesn't work correctly. How can I get
this back. I tried creating a new one, by copying and
pasting, but that didn't work. I really don't want to
create a new query because this one took so much time.
Click to expand...

It seems that with each parameter, you have a prompt. Can you make your
prompt such that the column would be obvious? Like "Enter pay period
beginning date" instead of "Enter date."
 
Back
Top