If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple parameter prompt in a query (InParam)
In earlier versions (2000) of Access I was able to create an InParam module
and have the query prompt me for multiple values separated by a ",". 2003 or 2007 does not allow me to. Anyone have any ideas? |
#2
|
|||
|
|||
Multiple parameter prompt in a query (InParam)
I just tested this and it worked great for me. In your query, on the field
you want to parameters on add this to the criteria. In([your message to the user to]) The In([]) will ask the user for the parameter values, and whatever you type between the [] will be what they are prompted with. With the In, you can add multiple values seperated by a comma. So if your users added 1,2,3 then all records with 1 2 or 3 would show up. No need for the " all they need to do is use the , -- Please remember to mark this post as answered if this solves your problem. "Marchelle" wrote: In earlier versions (2000) of Access I was able to create an InParam module and have the query prompt me for multiple values separated by a ",". 2003 or 2007 does not allow me to. Anyone have any ideas? |
#3
|
|||
|
|||
Multiple parameter prompt in a query (InParam)
Well, that didn't go well...
The prompt never appeared and the query returned all. "Ryan" wrote: I just tested this and it worked great for me. In your query, on the field you want to parameters on add this to the criteria. In([your message to the user to]) The In([]) will ask the user for the parameter values, and whatever you type between the [] will be what they are prompted with. With the In, you can add multiple values seperated by a comma. So if your users added 1,2,3 then all records with 1 2 or 3 would show up. No need for the " all they need to do is use the , -- Please remember to mark this post as answered if this solves your problem. "Marchelle" wrote: In earlier versions (2000) of Access I was able to create an InParam module and have the query prompt me for multiple values separated by a ",". 2003 or 2007 does not allow me to. Anyone have any ideas? |
Thread Tools | |
Display Modes | |
|
|