Private Sub Supp_Mess_Click()
Dim MaBase As Database
Dim StrSqlDelete As String
Dim i As Long
Set MaBase = CurrentDb
For i = 0 To Me.Lst_MessNonAffect.ListCount - 1
If Me.Lst_MessNonAffect.Selected(i) Then
StrSqlDelete = " Delete Tbl_RegrOutlook.NumAuto, Tbl_RegrOutlook.Nom_Client, "
StrSqlDelete = StrSqlDelete & " Tbl_RegrOutlook.CodeClient, Tbl_RegrOutlook.Commercial, "
StrSqlDelete = StrSqlDelete & " Tbl_RegrOutlook.Date, Tbl_RegrOutlook.Message, Tbl_RegrOutlook.Sujet, "
StrSqlDelete = StrSqlDelete & " Tbl_RegrOutlook.DateMAJ, Tbl_RegrOutlook.Maj_CpteRendu, "
StrSqlDelete = StrSqlDelete & " Tbl_RegrOutlook.ClientProspect FROM Tbl_RegrOutlook "
StrSqlDelete = StrSqlDelete & " Where ((Tbl_RegrOutlook.NumAuto) = '" & Me.Lst_MessNonAffect & ";"
Debug.Print StrSqlDelete
MaBase.Execute StrSqlDelete, dbFailOnError
End If
Next i
End Sub
Partager