Multiple search criteria form

[INOPOOL]

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

 

[jackd]

Please note that not all members have Acc2007 and above. Some of us can not open accdb
files.

 

[Joe4]

...and some of us are not allowed to download files from the internet. So posting linked files up on the internet for download reduces the pool of users who may be able to help.

That is why we recommend doing your best to explain the situation in detail and post screen images here instead of links to file downloads. It maximizes your chances of getting assistance.

 

[INOPOOL]

in .mdb version

thanks for the heads up.

 

[INOPOOL]

http://www.filedropper.com/language


here is the db file.

 

[INOPOOL]

Ideally, this is how I want the search form to be like:

It's a pretty simple design.

Language 1:

Language 2:

Language 3:

Language 4:

Language 5:

Search button

So if a user types in English for Language 1, Spanish for Language 2, and French for Language 3...and hit the search button, a list of employees who are trilingual in these three languages will come up. Thanks.

 

[jackd]

I found a link for multi language database here. Hope it's useful to you.
http://bytes.com/topic/access/insights/908560-how-implement-multi-lingual-database
I realize it's not the same topic, but I thought it might be useful.

Maybe as a reference

 

[INOPOOL]

Not quite relevant for what I was looking for....but thanks anyway! Any more help on this topic will be much appreciated!! thanks in advance!

 

[SaladProblems]

Hi. It's been a while since I did something like this, but I'll be back at my desk in a few hours and I can try it there to give you more precise help, but in the meantime, here's the gist of what I would do:

Create a query with multiple criteria. Give those criteria distinct names, so that when you run the query it prompts you to identify those criteria. If you name either your form fields after those query criteria or vice versa, you can then launch the query from the form and it will use the values in the corresponding fields.

I know I'm not describing this the best, and without using a bit of code I think you're going to have to put wild cards into the empty fields (not a huge deal, but a bit annoying/ugly), but it should work in the short run if you just need a quick fix.

Again, I'll mess around with it a bit when I get back to my desk if nothing too crazy comes up in the meantime.

 

[Joe4]

I would create a search form, and use VBA to build the SQL for the query you want to to return based on the entries/selections you have made.

Here is an example of one I helped someone out with some time ago:
http://www.mrexcel.com/forum/showpost.php?p=1619906