1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Private Sub CmdArchiver__Click()
Dim leSQL As String
leSQL = "INSERT INTO [t_archivage_projet] ( ID_projet, ID_visa, ID_budget, objet, compte, libellé, fournisseur, duree, Monnaie, taux_change, num_contrat, statut, periode, echeance, unite, imp_cc, KDAn, KDAn+1, KDAn+2, KDAn+3, KDAn+4, Année, DateArchive ) " & _
"SELECT [t_projet].ID_projet, [t_projet].ID_visa, [t_projet].ID_budget, [t_projet].objet, [t_projet].compte, [t_projet].libellé, [t_projet].fournisseur, [t_projet].duree, [t_projet].Monnaie, [t_projet].taux_change, [t_projet].num_contrat, [t_projet].statut, [t_projet].periode, [t_projet].echeance, [t_projet].unite, [t_projet].imp_cc, [t_projet].KDAn, [t-projet].KDAn+1, [t-projet].KDAn+2, [t_projet].KDAn+3, [t_projet].KDAn+4, [t_projet].Année, Date() AS DateArchive " & _
"FROM [t_projet]" & _
"WHERE (([t_projet].ID_projet) Not In (select ID_projet from [t_archivage_projet])) and imp_cc like '" & Nz(Me.ParamTitre_, "*") & "';"
DoCmd.SetWarnings False
DoCmd.RunSQL leSQL
DoCmd.SetWarnings True
Dim SQLSupp As String
SQLSupp = "DELETE FROM [t_projet] WHERE [t_projet].imp_cc like '" & Nz(Me.ParamTitre_, "*") & "';"
DoCmd.SetWarnings False
DoCmd.RunSQL SQLSupp
DoCmd.SetWarnings True
End Sub |
Partager