Recent content by Benderook

Hi ridder, as I pointed out it should work because I tested it in a query. IIF(DCount(....)>0, 'J','') means: if my count > 0 then show J ('J') else nothing ('') so there is nothing wrong here. I use this in a field on a continues form...

Thanks all, That (#9) is also not helping. The problem is the conversion from string to sql string I guess. I can replicate the iif part in query design and there it is working.

yes i think the iif function is correct. Its J or empty ->'' putting in something there doesnt help

ok here is what i am doing. The part that gives the error 3075 operator missing sSQLFilterGekoppeldLeeg = " AND IIF(DCount('contractnummer','tblKoppelContracten', 'inkoopnummer = '" & [Inkoopactiviteitnr] & "') > 0,'J','') " sSQLFilterGekoppeldLeeg is used below to make a recordsource...

Hello, Thank you for your quick reply. What I am doing is making a dynamic query with vba code. So I make a string which I use as a recordsource for a form. I need to be able to filter data on that form. Without the iif(dcount part it is working. The problem is that to build the string ("...

Hello, here is somthing I am stuck on. I get a syntax error, operator is missing SELECT qrySubOpmerkingenMijlpalen.MO_Opmerking, qrySubOpmerkingenMijlpalen.MO_Inkoopnummer, tblBedrijfsonderdeelhlp.Afkorting, tblInkoopprocessen.* FROM (tblInkoopprocessen LEFT JOIN qrySubOpmerkingenMijlpalen...

Hi there, My name is Ben Jansen and I am an access developer for more then 20 years. at the moment I am working on a project for Sanquin (bloodbank) in amsterdam. This project is partly migration and new build with Ms Access.