Access User-Friendly Form

[INOPOOL]

Hi,
Can someone guide me step-by-step on how to create a form that when i search for a language, it will give me all the employees that speak that language?

 

[INOPOOL]

Thanks a lot for your continued assistance.

I've looked at the db you posted. I can only select one language at a time and not multiple languages in the drop down menu. So I don't see how if a person spoke "English" and "French" that it will come up one after the other.

 

[alansidman]

I don't understand your response. Here are pictures from the database I uploaded and gave you the link to. How is this only one selection? Did you not upload the correct database.

and here are the results when you run the search.

what is wrong with this?

Here is the link one more time
http://www.box.net/shared/lf0hly548k

Alan

 

[INOPOOL]

Oh my!! This is so close to what I was hoping for to get. Thank you so much! The only thing is that it wouldn't filter out the other records. Say I only want a list of employees who speak "English" and "French" and it would just give me those. But I appreciate the help you have provided for me thus far. We only have to figure out how it would filter better. If anyone could help me out!!!

THANK YOU!

 

[INOPOOL]

Would it work if I line back the languages horizontally so the languages will show up side by side when you search. Can I put it back like this:

Lang1 Lang2 Lang 3 Lang 4 Lang 5


and under each Lang field will be the LangIDs.

 

[Norie]

If you want to find all trilingual employees why not count how many records they have in the personlanguage table and only return those that have 3 records.

You could do something similar if you want to look for specific languages.

 

[INOPOOL]

Sorry, I don't quite get what your trying to say. Is there some kind of code I need to put in. Thanks for helping out

 

[alansidman]

<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message -->
Would it work if I line back the languages horizontally so the languages will show up side by side when you search. Can I put it back like this:

Lang1 Lang2 Lang 3 Lang 4 Lang 5


and under each Lang field will be the LangIDs.

If you do that, you are back to where you began with a database that is not normalized.

 

[INOPOOL]

Someone told me to use "OR" instead of "AND" in the query. Would that help?

 

[alansidman]

Here is a tutorial on "or" and "and." watch it and then make an informed decision.

http://www.datapigtechnologies.com/flashfiles/andorinqbe.html

 

[INOPOOL]

I finally got it to work. But the only glitch is that if you search English for Lang 1 and Arabic for Lang 2, it doesn't work. All other combinations work.
Would you be able to figure out why? Below is the link to file.

http://www.box.net/shared/nv2dh9262l