Multiple Item Lookup

[Swiftrain]

Hi all,



I have a form that looks up items from another database that are associated with the item using a "textbox". Example: I type in "Apple" and click the search button, it will return tree, seeds, companion, gala, granny smith, etc.

It returns the items as such:
Associated | Search Item
tree Apple
Seeds Apple
Gala Apple

I can add multiple items to search for, but only one at a time. I there a way to paste multiple search items all at once? It just shows one cell and then a "New" row below it.

Thank you

[burrina]

I'm not sure of your design but if your using a form for data lookup, why not simply add more Text boxes?

[Swiftrain]

I have tried, but when copying from a spreadsheet it will not allow me to paste into the multiple textbox at once. I still have to input one at a time. The realtionships, codes, table, and everything works fine. I just can't seem to figure out how to Copy multiple items form a spreadsheet and paste them into a form then search them. It doesn't have to be a textbox control. Thanks for replying.

[burrina]

Are you trying to enter NEW data into an already created table from Excel via a form? If so, this is not correct! Are you using both a spreadsheet and Access at the same time? Please explain a little more.

[Swiftrain]

Sure, to be more clear.

I have a textbox on a form. When a user inputs their search word, it then populates a table which in turn goes to a query and reports out the results of the associated items. Currently, I can type into the textbox one item at a time and search. I can even type in multiple search items, but individually.

The user can get the information from anywhere, but more than likely they are looking at an Excel 2007 spreadsheet for the search items to look up. It would be great if they could copy down the rows of items in Excel then just paste them into the form to search, so they do not have to do it individually.

[ItsMe]

Perhaps there is a consultant in your area that can help you to customize your database.

[burrina]

You definitely need some understanding concerning Access. Do some studying. Buy some books, take some classes.

Good Luck With Your Project.

[Swiftrain]

Confused.

I just need a multiple item lookup form I can copy and paste to. The Db is finished. It works great. This was just a customization tweak, I thought. I apologize if the way I explain isn't the way you understand. But I really thought there would be a site, blog, tutorial online that would help with a Multiple value lookup that can be pasted into. I can't find it. Oh well thanks for your direction. I will go to the library.

[June7]

Where do you type 'apple' and what search button do you click? Are these the intrinsic Access tools or custom programmed interface? Where do you want to 'paste'?

Maybe these will help:

http://www.datapigtechnologies.com/f...tomfilter.html

http://allenbrowne.com/ser-50.html

[burrina]

Not a problem. We can't see what you do and don't understand it the way you do. It no doubt can be done, but without seeing it, it's hard to give you very much direction.
Did not mean to discourage you.

[Swiftrain]

Thanks you.

I parsed the text into CSV from the Excel spreadsheet, loaded it to the database via VB/Sql. And now the information they request comes to them on a separate sheet in the workbook. They will not need to open the Database any longer and can just work from Excel. It will save them time and get the information they need in a separate worksheet. Best work around I knew how to do on my limited Access knowledge.

[burrina]

Glad you got it sorted out. Best of luck with your projects!

[ItsMe]

...parsed the text into CSV from the Excel spreadsheet, loaded it to the database via VB/Sql...

If you can manage that, it is not a big deal to use VBA to generate SQL from CSV. There are limits to the length of the SQL statement to consider. If you run into limits with your workaround, it may be worthwhile to consider Access. It is Access' job to manage data and rather than creating large SQL strings you could use tables and JOINS. Just food for thought. There are worse things in the world than learning about RDBMS.