Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
Maar je gebruikt ook niet de IIF formule die ik je eerder aanraadde Bovendien heb je dan denk ik de syntax niet goed staan.
Expr1: IIf([Forms]![frm_Searchfile]![cmbDesignator] Is Null;True;[Doctype]=[Forms]![frm_Searchfile]![cmbDesignator])
SELECT qry_files.siteid,
qry_files.area,
qry_files.description,
qry_files.doctype,
qry_files.fileext,
qry_files.fileid,
qry_files.supplierid,
qry_files.keyword,
qry_files.drawtype,
[forms]![frm_searchfile_admin]![cmbdesignator] AS Expr1,
[forms]![frm_searchfile_admin]![cmblocation] AS Expr2,
[forms]![frm_searchfile_admin]![CmbDiscipline] AS Expr3,
[forms]![frm_searchfile_admin]![cmbSupplier] AS Expr4,
[forms]![frm_searchfile_admin]![cmbtag] AS Expr5,
[forms]![frm_searchfile_admin]![cmbArea1] AS Expr6,
[forms]![frm_searchfile_admin]![cmbArea2] AS Expr7
FROM qry_files
WHERE
( qry_files.siteid = [forms]![frm_searchfile_admin]![cmblocation]
OR [forms]![frm_searchfile_admin]![cmblocation] IS NULL)
AND
(qry_files.doctype = [forms]![frm_searchfile_admin]![cmbdesignator]
OR [forms]![frm_searchfile_admin]![cmbdesignator] IS NULL)
AND
( qry_files.drawtype = [forms]![frm_searchfile_admin]![CmbDiscipline]
OR [forms]![frm_searchfile_admin]![CmbDiscipline] IS NULL)
AND
( qry_files.supplierid = [forms]![frm_searchfile_admin]![cmbSupplier]
OR [forms]![frm_searchfile_admin]![cmbSupplier] IS NULL)
AND
( qry_files.keyword = [forms]![frm_searchfile_admin]![cmbtag]
OR [forms]![frm_searchfile_admin]![cmbtag] IS NULL)
AND
(qry_files.area between [forms]![frm_searchfile_admin]![cmbArea1] and [forms]![frm_searchfile_admin]![cmbArea2]
OR [forms]![frm_searchfile_admin]![cmbArea1] IS NULL
OR [forms]![frm_searchfile_admin]![cmbArea2] IS NULL)
ORDER BY qry_files.siteid,
qry_files.area,
qry_files.description;
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.