Parameter Query Multiple Input enteries

22strider

Active Member
Joined
Jun 11, 2007
Messages
302
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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

22strider

Active Member
Joined
Jun 11, 2007
Messages
302
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
 

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,793
Office Version
  1. 2019
Platform
  1. Windows
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".
 

Watch MrExcel Video

Forum statistics

Threads
1,122,819
Messages
5,598,289
Members
414,223
Latest member
Accountant2B

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
Top