Private Sub Form_Close()
Dim MaBase As Database
Dim sqldel As String, SqlInsert2 As String, StrSql As String
Set MaBase = CurrentDb
sqldel = "DELETE Tbl_TempRegrOutlook.*"
sqldel = sqldel & " FROM Tbl_TempRegrOutlook;"
CurrentDb.Execute sqldel
'ajoute les éléments à la table temporaire
SqlInsert2 = "INSERT INTO Tbl_TempRegrOutlook ( NumAuto, Nom_Client, CodeClient, Commercial, "
SqlInsert2 = SqlInsert2 & " [Date], Message, Sujet, DateMAJ, Maj_CpteRendu ) "
SqlInsert2 = SqlInsert2 & " SELECT Tbl_RegrOutlook.NumAuto, Tbl_RegrOutlook.Nom_Client, "
SqlInsert2 = SqlInsert2 & " Tbl_RegrOutlook.CodeClient, Tbl_RegrOutlook.Commercial, Tbl_RegrOutlook.Date, "
SqlInsert2 = SqlInsert2 & " Tbl_RegrOutlook.Message, Tbl_RegrOutlook.Sujet, Tbl_RegrOutlook.DateMAJ, "
SqlInsert2 = SqlInsert2 & " Tbl_RegrOutlook.Maj_CpteRendu FROM Tbl_RegrOutlook "
SqlInsert2 = SqlInsert2 & " WHERE (((Tbl_RegrOutlook.CodeClient) Is Null Or (Tbl_RegrOutlook.CodeClient)=""" & """)"
SqlInsert2 = SqlInsert2 & " AND ((Tbl_RegrOutlook.Maj_CpteRendu)=False)) AND ((Tbl_RegrOutlook.Commercial)= " & "'" & Forms("Frm_Prospects")!Cbo_Cial.Value & "');"
CurrentDb.Execute SqlInsert2
'Crée la chaine SQL correspondant à la recherche des éléments qui restent à mettre à jour
StrSql = "SELECT Tbl_TempRegrOutlook.Nom_Client, Tbl_TempRegrOutlook.CodeClient, Tbl_TempRegrOutlook.Commercial, "
StrSql = StrSql & " Tbl_TempRegrOutlook.Date , Tbl_TempRegrOutlook.Message, Tbl_TempRegrOutlook.Sujet, "
StrSql = StrSql & " Tbl_TempRegrOutlook.DateMAJ, Tbl_TempRegrOutlook.Maj_CpteRendu, Tbl_TempRegrOutlook.Numauto FROM Tbl_TempRegrOutlook "
StrSql = StrSql & " WHERE ((Tbl_TempRegrOutlook.Maj_CpteRendu) = False) "
StrSql = StrSql & " ORDER BY Tbl_TempRegrOutlook.Commercial;"
'Ouvre le recordset
Set MaBase = CurrentDb.OpenRecordset(StrSql)
Forms("Sfrm_TempRegrOutlook").Form.RecordSource = StrSql
End Sub
Partager