Search results

That's great. Worked like a charm. Only I had to took the ' ' on (...) '" & Forms![Pesquisa por Sala]![Verificação13] & "' to work, I dunno very well but I think it's because the true/false values come out with 0 or 1. Thankx once again best regards.

I'm portuguese, so [Formulários] = [Forms] ... and [txSala] is String [Verificação13] is true/false. SQL2 = "SELECT Crianças.[-Email], Crianças.[+Email]" & _ "FROM Salas" & _ "LEFT JOIN Crianças ON Salas.IDSala_salas = Crianças.IDSalas" & _ "WHERE (((Salas.Campo1)='" &...

Hi, my brain is getting hot... I dunoo what to do anymore, it keeps showing 2465 error and I tried almost everything. I'm a newbie and this code was found on internet, but was modifyed to my db. I have read many many forums but I have found no solutions. I'm trying to send an email to recepients...