1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
|
private sub OuvrirEtatFiltrer
dim db as database:set db=currentdb
dim q as querydef:set q=db.querydefs("filtre")
dim SQL as string:sql=q.sql
set q=nothing
sql=left(sql,len(sql)-1):'elève le ; en fin de chaine
If Me.choix_ok Then
If cmd = True Then
SQL = SQL & " Or procedure.conclusion = 'OK'"
Else
cmd = True
SQL = Left(SQL, Len(s) - n)
SQL = SQL & " And (procedure.conclusion = 'OK'"
End If
End If
If Me.marchepas Then
If cmd = True Then
SQL = SQL & " Or procedure.conclusion = 'Ne fonctionne pas'"
Else
cmd = True
SQL = Left(SQL, Len(s) - n)
SQL = SQL & " And (procedure.conclusion = 'Ne fonctionne pas'"
End If
End If
If Me.ameliorer Then
If cmd = True Then
SQL = SQL & " Or procedure.conclusion = 'A améliorer'"
Else
cmd = True
SQL = Left(SQL, Len(s) - n)
SQL = SQL & " And (procedure.conclusion = 'A améliorer'"
End If
End If
If cmd = True Then
SQL = SQL & ")"
SQL = SQL & ";"
End If
stDocName = "filtre"
DoCmd.OpenReport stDocName, acPreview,,,,SQL
db.close:set db=nothing
end sub |
Partager