Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Parameters
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Parameters
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. 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. 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." -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Query Parameters | Excel Discussion (Misc queries) | |||
MS Query - 2 Parameters | Excel Discussion (Misc queries) | |||
Multiple parameters in MS Query | Excel Discussion (Misc queries) | |||
Query Parameters | Excel Discussion (Misc queries) | |||
Help : Using Parameters with External Date Query | Excel Discussion (Misc queries) |