Multiple search criteria form

INOPOOL

New Member
Joined
Feb 3, 2011
Messages
43
Attached is a language db that someone nicely provided for me. I would like to modify the search form to a form that I can search multiple languages on. For instance, if I would like to see a list of employees who speak English, French, and Spanish, I could put that in and when I hit search, a list of employees who speak the three languages will come up. Can someone help me on that? Thanks.

http://www.box.net/shared/yod5tyixj4
 
If you're iffy on building the SQL yourself, you can make the query via the query builder and then view it in SQL mode. After that you can copy/paste it into your macro and edit as necessary.
 
Upvote 0

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
First, I'd just like to thank everyone's help in this thread.

It's been weeks that I'm trying to figure how I can create a search form for multiple languages.

Maybe because i don't know any vba coding....so please continue to help if you can! Let me know if you need me to send you copies of my files. Greatly appreciated it!
 
Upvote 0

Forum statistics

Threads
1,224,584
Messages
6,179,687
Members
452,938
Latest member
babeneker

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