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
| If Not IsNull(Me.cb_msn) And Not IsNull(Me.cb_poste) Then
CurrentDb.QueryDefs("R_DQA_preaff").SQL = "SELECT T_CA_Serial.numero_serie, T_CA_Serial.code_ca " & _
"FROM T_CA_Serial INNER JOIN T_Affectation ON T_CA_Serial.id_CA = T_Affectation.ID_CA_new " & _
"WHERE (((T_Affectation.Preaffectation)=True) AND ((T_Affectation.MSN_new)=" & Me.cb_msn & "));"
CurrentDb.QueryDefs("R_DQA_aff").SQL = "SELECT T_CA_Serial.code_ca, T_CA_Serial.numero_serie " & _
"FROM T_CA_Serial INNER JOIN T_Affectation ON T_CA_Serial.id_CA = T_Affectation.ID_CA_new " & _
"WHERE (((T_CA_Serial.MSN)=" & Me.cb_msn & "));"
CurrentDb.QueryDefs("R_DQA_inst").SQL = "SELECT T_CA_Serial.code_ca, T_CA_Serial.numero_serie " & _
"FROM T_Postes RIGHT JOIN (T_CA_Serial INNER JOIN T_Installation ON T_CA_Serial.id_CA = T_Installation.ID_CA) ON T_Postes.CA_Code = T_CA_Serial.code_ca " & _
"WHERE (((T_Installation.MSN)=" & Me.cb_msn & ") AND ((T_Installation.Currently_installed)=True));"
CurrentDb.QueryDefs("R_DQA_tout").SQL = "SELECT T_Postes.Poste, T_Postes.CA_Code, R_DQA_preaff.numero_serie, R_DQA_aff.numero_serie, R_DQA_inst.numero_serie " & _
"FROM R_DQA_inst RIGHT JOIN ((R_DQA_aff RIGHT JOIN T_Postes ON R_DQA_aff.code_ca = T_Postes.CA_Code) LEFT JOIN R_DQA_preaff ON T_Postes.CA_Code = R_DQA_preaff.code_ca) ON R_DQA_inst.code_ca = T_Postes.CA_Code " & _
"WHERE (((T_Postes.Poste)='" & Me.cb_poste & "'))" & _
"ORDER BY T_Postes.CA_Code;"
If CurrentProject.AllReports("E_DQA").IsLoaded Then
DoCmd.Close acReport, "E_DQA", acSaveNo
End If
DoCmd.OpenReport "E_DQA", acViewPreview, , , acWindowNormal
Else
MsgBox "Veuillez saisir les deux champs!", vbCritical, "Données manquantes!"
End If
Exit Sub |
Partager