Parameter Query Multiple Input enteries

22strider

Active Member
Joined
Jun 11, 2007
Messages
311
Hello Friends

Is it possible to enter a list in a MS Access parameter query?

I prepared a small application for some users at work. In this application they click on a button and a parameter query runs background and lets them enter a part number. After that this application gives specific information regarding that part number. But most of the times the users need information for more than one part numbers and they have list of those part numbers (usually in Excel). Entering part numbers one by one is very time consuming and in efficient because then they have to organize the query results as well.

Is there a way to let them enter (preferably paste) the list of part numbers in the application? Then the query can generate a report rather than spitting results one at a time.

Any ideas?

Thanks
Rajesh
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Thank you; it will definitely be a step forward. The ideal solution would allow pasting data copied from excel but this will be an improvement.

Thanks again
Rajesh
 
Upvote 0
You would need to alter your query so that it doesn't use a parameter query. For instance, a datasheet (subform?) could hold one or more values, and allows users to paste from Excel. Then you only need to join on this "lookup table".
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,995
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top