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
| Public Function CompteSA() As Long
Dim VARCJ As String
VARCJ = "SA"
CompteSA = CompteCJ(VARCJ)
End Function
Public Function CompteCJ(Variable As String) As Long
Dim R_Cpt As String
MsgBox (Variable)
R_Cpt = "SELECT COUNT (T_IdentiteStructure.IDS) as Result "
R_Cpt = R_Cpt & " FROM T_IdentiteStructure,T_CategorieJuridique,T_GrpCJ,T_LienCJ,T_Membre"
R_Cpt = R_Cpt & " WHERE T_IdentiteStructure.CodeCJ = T_CategorieJuridique.CodeCJ"
R_Cpt = R_Cpt & " AND T_CategorieJuridique.CodeCJ = T_LienCJ.CodeCJ"
R_Cpt = R_Cpt & " AND T_LienCJ.CodeGrpCJ = T_GrpCJ.CodeGrpCJ"
R_Cpt = R_Cpt & " AND T_GrpCJ.LibGrpCJ =" & Variable & Char(34) ""
R_Cpt = R_Cpt & " AND T_IdentiteStructure.Membre = T_Membre.CodeM"
If cboMembre.Value <> "" Then
R_Cpt = R_Cpt & " AND T_IdentiteStructure.Membre=" & cboMembre.Value & ""
End If
'Lancement de la requête
Dim db As dao.Database: Set db = CurrentDb
Dim r As dao.Recordset: Set r = db.OpenRecordset(R_Cpt)
If r.RecordCount <> 0 Then
result = r![result]
Else
result = 0
End If
r.Close: Set r = Nothing
Set db = Nothing
'Affectation du résultat de la requête
CompteCJ = result
End Function |