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
| ' Ouverture de la base de données
Set db = DBEngine.OpenDatabase(MaBase)
SQL = "Select IDPlageAgeCategorie, PACDebut, PACFin From tblPlageAgeCategorie Where PACDebut<=" & AgeCat & " and PACFin>=" & AgeCat & ""
'Ouverture du recordset
Set rst1 = db.OpenRecordset(SQL, dbOpenForwardOnly, dbReadOnly)
While Not (rst1.EOF)
IDPAC = rst1.Fields(0)
strPACDebut = rst1.Fields(1)
strPACFin = rst1.Fields(2)
'MsgBox ("Bienvenue")
MaPlageTest = 5
' Ouverture de la base de données
Set db = DBEngine.OpenDatabase(MaBase)
sSQL = "SELECT DISTINCT TypeControle, PlageAge, min(Frequence) FROM(SELECT tblSubitSpecifiquement.num_tblPlageAgeCategorie As PlageAge, tblSubitSpecifiquement.num_tblTypeControle As TypeControle, tblSubitSpecifiquement.FrequenceSpecifique As Frequence FROM ((tblCatRisque INNER JOIN tblPlageAgeCategorie ON tblCatRisque.IDCatRisque = tblPlageAgeCategorie.num_tblCatRisque) INNER JOIN tblRegroupe ON tblCatRisque.IDCatRisque = tblRegroupe.num_tblCatRisque) INNER JOIN tblSubitSpecifiquement ON tblPlageAgeCategorie.IDPlageAgeCategorie = tblSubitSpecifiquement.num_tblPlageAgeCategorie WHERE tblRegroupe.num_tblEmploye=18678 and tblSubitSpecifiquement.num_tblPlageAgeCategorie = " & IDPAC & " UNION Select num_tblPlageAge As PlageAge, num_tblTypeControle As TypeControle, FrequenceNormale As Frequence FROM tblSubitNormalement WHERE num_tblPlageAge=" & MaPlageTest & ") GROUP BY TypeControle, PlageAge, Frequence"
' Ouverture du recordset
Set rst = db.OpenRecordset(sSQL, dbOpenForwardOnly, dbReadOnly)
While Not rst.EOF
strMessage = rst.Fields(1) & vbCr & rst.Fields(0) & vbCr & rst.Fields(2)
MsgBox (strMessage)
If rst.EOF Then
rst1.MoveNext
Else
rst.MoveNext
End If
Wend
rst1.MoveNext
Wend |
Partager