Parameter Query Multiple Input enteries

[22strider]

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

 

[Smitty]

You can use a List Box on a form to let them select the records they want, then use that in the query criteria.

Here are a few links on how to set it up:

http://www.databasedev.co.uk/query_using_listbox.html

http://access.mvps.org/access/forms/frm0007.htm

HTH,

 

[22strider]

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]

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".