Originally Posted by
pbaldy
Happy to help!
Hello again! I've had a long summer break and recently got back to this little project as described above! I tried applying the fix in your link, as follows (and excuse me if I am doing something obviously stupid here, I'm not sure I understand 100%):
Code:
SELECT [Män hospital].År, [Män hospital].[Efternamn 1], [Män hospital].[Efternamn 2], [Män hospital].[Förnamn 1], [Män hospital].[Förnamn 2], [Män hospital].[Förnamn 3], [Män hospital].Ålder, [Män hospital].År2, [Män hospital].Månad, [Män hospital].Dag, [Män hospital].[Födelselän/-ort], [Män hospital].Boendeort, [Män hospital].Yrke, [Män hospital].Utskriven, [Män hospital].OrsakFROM [Män hospital]
WHERE (
(([Män hospital].År) Like "*" & [Forms]![Sok]![inskrAr] & "*" OR ([Män hospital].År) Is Null) AND
((([Män hospital].[Efternamn 1]) Like "*" & [Forms]![Sok]![Efternamn] & "*" OR ([Män hospital].[Efternamn 1]) Is Null) OR
(([Män hospital].[Efternamn 2]) Like "*" & [Forms]![Sok]![Efternamn] & "*" OR ([Män hospital].[Efternamn 2]) Is Null)) AND
((([Män hospital].[Förnamn 1]) Like "*" & [Forms]![Sok]![Fornamn] & "*" OR ([Män hospital].[Förnamn 1]) Is Null) OR
(([Män hospital].[Förnamn 2]) Like "*" & [Forms]![Sok]![Fornamn] & "*" OR ([Män hospital].[Förnamn 2]) Is Null) OR
(([Män hospital].[Förnamn 3]) Like "*" & [Forms]![Sok]![Fornamn] & "*" OR ([Män hospital].[Förnamn 3]) Is Null)) AND
(([Män hospital].Ålder) Like "*" & [Forms]![Sok]![Alder] & "*" OR ([Män hospital].Ålder) Is Null) AND
(([Män hospital].År2) Like "*" & [Forms]![Sok]![fAr] & "*" OR ([Män hospital].År2) Is Null) AND
(([Män hospital].Månad) Like "*" & [Forms]![Sok]![fMan] & "*" OR ([Män hospital].Månad) Is Null) AND
(([Män hospital].Dag) Like "*" & [Forms]![Sok]![fDag] & "*" OR ([Män hospital].Dag) Is Null) AND
(([Män hospital].[Födelselän/-ort]) Like "*" & [Forms]![Sok]![fLan] & "*" OR ([Män hospital].[Födelselän/-ort]) Is Null) AND
(([Män hospital].Boendeort) Like "*" & [Forms]![Sok]![boendeOrt] & "*" OR ([Män hospital].Boendeort) Is Null) AND
(([Män hospital].Yrke) Like "*" & [Forms]![Sok]![Yrke] & "*" OR ([Män hospital].Yrke) Is Null) AND
(([Män hospital].Utskriven) Like "*" & [Forms]![Sok]![utskrDatum] & "*" OR ([Män hospital].Utskriven) Is Null) AND
(([Män hospital].Orsak) Like "*" & [Forms]![Sok]![orsak] & "*" OR ([Män hospital].Orsak) Is Null)
);
However whatever I input anywhere in the form now, it returns every single record? What am I doing wrong?
EDIT: I think I did it! I wrote like this instead:
Code:
WHERE ((([Män hospital].År) Like "*" & [Forms]![Sok]![inskrAr] & "*" Or ([Män hospital].År) Is Null) AND
(([Män hospital].[Efternamn 1]) Like "*" & [Forms]![Sok]![Efternamn] & "*" OR ([Män hospital].[Efternamn 1]) Is Null) AND
(([Män hospital].[Efternamn 2]) Like "*" & [Forms]![Sok]![Efternamn] & "*" OR ([Män hospital].[Efternamn 2]) Is Null) AND
(([Män hospital].[Förnamn 1]) Like "*" & [Forms]![Sok]![Fornamn] & "*" OR ([Män hospital].[Förnamn 1]) Is Null) AND
(([Män hospital].[Förnamn 2]) Like "*" & [Forms]![Sok]![Fornamn] & "*" OR ([Män hospital].[Förnamn 2]) Is Null) AND
(([Män hospital].[Förnamn 3]) Like "*" & [Forms]![Sok]![Fornamn] & "*" OR ([Män hospital].[Förnamn 3]) Is Null) AND
(([Män hospital].Ålder) Like "*" & [Forms]![Sok]![Alder] & "*" OR ([Män hospital].Ålder) Is Null) AND
(([Män hospital].År2) Like "*" & [Forms]![Sok]![fAr] & "*" OR ([Män hospital].År2) Is Null) AND
(([Män hospital].Månad) Like "*" & [Forms]![Sok]![fMan] & "*" OR ([Män hospital].Månad) Is Null) AND
(([Män hospital].Dag) Like "*" & [Forms]![Sok]![fDag] & "*" OR ([Män hospital].Dag) Is Null) AND
(([Män hospital].[Födelselän/-ort]) Like "*" & [Forms]![Sok]![fLan] & "*" OR ([Män hospital].[Födelselän/-ort]) Is Null) AND
(([Män hospital].Boendeort) Like "*" & [Forms]![Sok]![boendeOrt] & "*" OR ([Män hospital].Boendeort) Is Null) AND
(([Män hospital].Yrke) Like "*" & [Forms]![Sok]![Yrke] & "*" OR ([Män hospital].Yrke) Is Null) AND
(([Män hospital].Utskriven) Like "*" & [Forms]![Sok]![utskrDatum] & "*" OR ([Män hospital].Utskriven) Is Null) AND
(([Män hospital].Orsak) Like "*" & [Forms]![Sok]![orsak] & "*" OR ([Män hospital].Orsak) Is Null)
);
And now it seems to work as intended. But now comes the followup question - how do I make this into a search form that I can put on a public facing (not online, but its computer we have in our researcher's room) computer somehow? It needs:
1. The results need to be presented in a better way, like preferably in a list box underneath the search fields in the search form
2. They need to be presented without the ability to edit any of them or the database or anything
How should I do this?