Replies

Hello Gary,

Thanks for the quick and easy sollution.
I will pass it thru to my brother

Thanks again

Sam,

The world is very lucky that I’m not a chemist..

Thanks for the remark and the program additions
I will send them to my brother to get it al correct.

Greetings,

PAtrick

Wow

Thank you all for the responses.
I thought that is was some kind of corruption.So I will copy the data to a new workbook. Thanks for the macro Sam.

Thanks for thinking with me
Have a nice weekend.

Hello Sam,

How dumb could I be.
I just forgot that PoPo 2000 has macros

Thanks it works.

Maria,

Why would you like to remove this period?

Thanks for the example

The SQL statement you use, I can even read, wow.
—
SELECT Connect.IDName, Connect.IDLanguage, Names.Name
FROM [Names] INNER JOIN [Connect] ON Names.IDName = Connect.IDName
WHERE (((Connect.IDName) In (SELECT Connect.IDName FROM Connect WHERE (((Connect.IDLanguage)=1))) AND ((Connect.IDLanguage)=3));
—

But could you explane to me, how I could write ‘on the fly’ the SQL code when a user selects some languages from a form?
I’m new to VBA and SQL, but it looks very powerfull

Greetings,
Patrick Schouten

Hello Jackson,

When I try your solution the query result is showing nothing. I could by that I’m doing something wrong (would’t be the first time hihi)
Maybe you could send me an working example.

Greetings,
Patrick Schouten

Hello Rory,

Thanks for this neat sollution.
This will do the trick… But now lets move to the next step.
I want to show a form on the screen where a user can select any number of lanuages.
How can I change the query to refect any outcome of the form input, to show a list of people that speaks ALL the selected languages?

(It just looked as a simple question and now I see things in Access happen that moves me to a new level)

Greetings,
Patrick Schouten

Hello Steve,

Thanks, this is what I also did,
but now I ONLY want to see all people who speak Dutch AND English (not an OR).

Succes,

PAtrick Schouten

Table1 : Names
Fields: IDName (key), Name
Table2 : Language
Fields: IDLanguage (key), Language
Table 3: Connect
Fields: IDName, IDLanguage (this of the use of the Lookup Wizard)

Yes there is an many-to-many relation between Name and Language, that is the reson for the intersectiontable Connect.

Running a query on the table Connect gives a problem, because it only contains numbers and not the Languagenames to put in a criteria.
Also is it not possible to have AND critera; ‘Show me all names that speak Dutch and France’.

Greetings,
Patrick Schouten

David,

I understand. I was trying to attach a example database, but that seems to be a problem here on my work, so I will attach a database later on to make it more clear.
Thanks for looking.

Greetings,

Patrick Schouten

Hello Sean,

Well after searching over the Internet I found a solution for your problem.
Look at http://members.home.nl/cvonken/lookout/index.htm
There you will find a program to do the trick

Edited to add hotlink

Thanks, Arianna,

This seems to be the best solution

If it is not possible in Word, you could check it from the HTML pages, by using Frontpage. This program has this very usefull function to check all Hyperlinks

Yes, thanks JMW

This works fine