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?

 

[alansidman]

Try adapting this to your situation:

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

Alan

 

[INOPOOL]

Thanks for the video

But I followed it and tried it. When I type in "English" for one of the languagues, it only brought up like 5 people. I know there's more people than that who speaks English. How come it's like that? Is there another helpful video that you know about that can help me out? Thanks

 

[alansidman]

Without seeing your layout, it is difficult to say. What does your table layout look like? Are all languages listed in one field? Or do you have multiple language fields? If multiple fields, then you probably have a normalization issue.

 

[INOPOOL]

can i send you the database and can you help me look at it?

thanks!

 

[alansidman]

Suggest you post it on box.net or some similar location and then post the link here on MrExcel. Then many more than just me can look at it and offer help. You want the widest possible exposure.
Alan

 

[INOPOOL]

how do i post it on this forum?

 

[INOPOOL]

Please help on database so I can search for the languages and the list of employees will come up.

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

 

[alansidman]

First, as I suspected your db is not normalized. You should have only one field for language and not five. You should set up a separate table for the languages, then have a one to many relationship between the employee table and the language table.

Now to the current set up of your query, you have placed your criteria on the same line for each language. This creates a criteria logic of must be English in Language1 field and Language2 field and Language3 field, etc. To make this work with the current set up, you will need to put the criteria on separate lines to create an "OR" effect.

Look at this video to make sure you understand what I am saying here.
http://www.datapigtechnologies.com/flashfiles/andorinqbe.html

Alan

 

[INOPOOL]

I tried putting the criteria in the "OR" rows, but when I put in "English" for Language 1 and "Spanish" for Language 2, it wouldn't give me the records containing only those records.

What should I do?