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
|
|||
|
|||
Access queries with dropdowns list for parameters?
How can I make a query so that the criteria for the parameters are a drop
down list of the values in that field. For example, if the field is "Country of Project", the user can choose from the available countries via a drop down list rather than enter in "Kenya" in the criteria box. Also, is it possible to let the user select more than one country (via using the Control botton while selecting?) from this drop down list? I've been trying to figure this out for days. ANY HELP would be greatly appreciated!! Thanks. |
#2
|
|||
|
|||
Emily Bright wrote:
How can I make a query so that the criteria for the parameters are a drop down list of the values in that field. For example, if the field is "Country of Project", the user can choose from the available countries via a drop down list rather than enter in "Kenya" in the criteria box. Also, is it possible to let the user select more than one country (via using the Control botton while selecting?) from this drop down list? I've been trying to figure this out for days. ANY HELP would be greatly appreciated!! Thanks. The self-prompting parameter feature in Access queries is very limited and seldom used in a "production quality" application. If you want the user to be able to select from a list you need to use a form and have the query reference a ComboBox on the form for its parameter instead of using the [Enter your parameter] method in the query. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Access queries with dropdowns list for parameters?
"Rick Brandt" wrote: Emily Bright wrote: How can I make a query so that the criteria for the parameters are a drop down list of the values in that field. For example, if the field is "Country of Project", the user can choose from the available countries via a drop down list rather than enter in "Kenya" in the criteria box. Also, is it possible to let the user select more than one country (via using the Control botton while selecting?) from this drop down list? I've been trying to figure this out for days. ANY HELP would be greatly appreciated!! Thanks. The self-prompting parameter feature in Access queries is very limited and seldom used in a "production quality" application. If you want the user to be able to select from a list you need to use a form and have the query reference a ComboBox on the form for its parameter instead of using the [Enter your parameter] method in the query. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com How can I use a list box or a combo box in a form as a query parameter |
#4
|
|||
|
|||
Access queries with dropdowns list for parameters?
Hi Rick,
I have a similar problem. I've created a combo box with a list of topics which the user can select. In my Query window under Criteria, I've type: = [Forms]![SelectCategory].[Combo2] When I run my query, it does not capture the value i selected from the combo box. I tested my query using just a specific value; eg in Criteria, I keyed in "*SAP*", and i return all the items which is related to SAP. Care to help. "Rick Brandt" wrote: Emily Bright wrote: How can I make a query so that the criteria for the parameters are a drop down list of the values in that field. For example, if the field is "Country of Project", the user can choose from the available countries via a drop down list rather than enter in "Kenya" in the criteria box. Also, is it possible to let the user select more than one country (via using the Control botton while selecting?) from this drop down list? I've been trying to figure this out for days. ANY HELP would be greatly appreciated!! Thanks. The self-prompting parameter feature in Access queries is very limited and seldom used in a "production quality" application. If you want the user to be able to select from a list you need to use a form and have the query reference a ComboBox on the form for its parameter instead of using the [Enter your parameter] method in the query. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#5
|
|||
|
|||
Access queries with dropdowns list for parameters?
Hi Pirduan,
You have to requery the combo box after you select the data. Use the On Exit event: me.combo2.requery. Kathleen "Pirduan" wrote: Hi Rick, I have a similar problem. I've created a combo box with a list of topics which the user can select. In my Query window under Criteria, I've type: = [Forms]![SelectCategory].[Combo2] When I run my query, it does not capture the value i selected from the combo box. I tested my query using just a specific value; eg in Criteria, I keyed in "*SAP*", and i return all the items which is related to SAP. Care to help. "Rick Brandt" wrote: Emily Bright wrote: How can I make a query so that the criteria for the parameters are a drop down list of the values in that field. For example, if the field is "Country of Project", the user can choose from the available countries via a drop down list rather than enter in "Kenya" in the criteria box. Also, is it possible to let the user select more than one country (via using the Control botton while selecting?) from this drop down list? I've been trying to figure this out for days. ANY HELP would be greatly appreciated!! Thanks. The self-prompting parameter feature in Access queries is very limited and seldom used in a "production quality" application. If you want the user to be able to select from a list you need to use a form and have the query reference a ComboBox on the form for its parameter instead of using the [Enter your parameter] method in the query. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#6
|
|||
|
|||
Access queries with dropdowns list for parameters?
Same problem here. Still unable to resolve it. kindly help.
"Pirduan" wrote: Hi Rick, I have a similar problem. I've created a combo box with a list of topics which the user can select. In my Query window under Criteria, I've type: = [Forms]![SelectCategory].[Combo2] When I run my query, it does not capture the value i selected from the combo box. I tested my query using just a specific value; eg in Criteria, I keyed in "*SAP*", and i return all the items which is related to SAP. Care to help. "Rick Brandt" wrote: Emily Bright wrote: How can I make a query so that the criteria for the parameters are a drop down list of the values in that field. For example, if the field is "Country of Project", the user can choose from the available countries via a drop down list rather than enter in "Kenya" in the criteria box. Also, is it possible to let the user select more than one country (via using the Control botton while selecting?) from this drop down list? I've been trying to figure this out for days. ANY HELP would be greatly appreciated!! Thanks. The self-prompting parameter feature in Access queries is very limited and seldom used in a "production quality" application. If you want the user to be able to select from a list you need to use a form and have the query reference a ComboBox on the form for its parameter instead of using the [Enter your parameter] method in the query. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#7
|
|||
|
|||
Access queries with dropdowns list for parameters?
Are you certain that the combo box is bound to the column you think it is?
In otherwords, does [Forms]![SelectCategory].[Combo2] return the value you think it should? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Imran" wrote in message ... Same problem here. Still unable to resolve it. kindly help. "Pirduan" wrote: Hi Rick, I have a similar problem. I've created a combo box with a list of topics which the user can select. In my Query window under Criteria, I've type: = [Forms]![SelectCategory].[Combo2] When I run my query, it does not capture the value i selected from the combo box. I tested my query using just a specific value; eg in Criteria, I keyed in "*SAP*", and i return all the items which is related to SAP. Care to help. "Rick Brandt" wrote: Emily Bright wrote: How can I make a query so that the criteria for the parameters are a drop down list of the values in that field. For example, if the field is "Country of Project", the user can choose from the available countries via a drop down list rather than enter in "Kenya" in the criteria box. Also, is it possible to let the user select more than one country (via using the Control botton while selecting?) from this drop down list? I've been trying to figure this out for days. ANY HELP would be greatly appreciated!! Thanks. The self-prompting parameter feature in Access queries is very limited and seldom used in a "production quality" application. If you want the user to be able to select from a list you need to use a form and have the query reference a ComboBox on the form for its parameter instead of using the [Enter your parameter] method in the query. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#8
|
|||
|
|||
Access queries with dropdowns list for parameters?
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
object dependency doesn't work / apprear on the View pulldown menu | WylieCoyote | General Discussion | 10 | December 15th, 2004 08:45 AM |
Can mailing list in Works 4.5 be moved into Access | Monica | New Users | 1 | October 17th, 2004 08:35 AM |
Bitwise And | Sam Hobbs | Running & Setting Up Queries | 44 | October 14th, 2004 04:19 AM |
SQL Server 2000 Stored Procedures to MS Access 2000 Queries | CS | General Discussion | 4 | July 15th, 2004 03:27 AM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |