1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Select Case Nz(E_NumAnimation, 0)
Case 0 ' Insert il s'agit d'une nouvelle Saisie
R_Sql = "INSERT INTO [T_Animation]" & _
"(DateDemandeAnimation,IdSocieteFacturation,code,IdCommercial," & _
"Jour1,Jour2,Jour3,Jour4,Jour5,DureeJour,MoisAnimation,EtatDemandeAnimation," & _
"CommentaireDemandeAnimation,ConfirmationCommercial,ConfirmationSocieteAnimation,EntreeSocieteAnimation,EntreeMagasin," & _
"IdSocieteAnimation,NomAnimateur,EstimationFacture,FactureReference," & _
"FactureMontant,DateValidationFacture,AnneeSemaine,CommentaireGlobal)" & _
" VALUES (" & _
Convert_DateUS_Short(Nz(Me.E_DateDemandeAnimation, Date)) & ", " & Nz(Me.E_SocieteFacturation, 0) & ", " & _
"'" & Protected_Quote(Nz(E_Magasin, "")) & "', " & Nz(Me.E_Commercial, 0) & ", " & Convert_DateUS_Short(Nz(Me.E_Jour1, Date)) & ", " & _
Convert_DateUS_Short(Nz(Me.E_Jour2, Date)) & ", " & Convert_DateUS_Short(Nz(Me.E_Jour3, Date)) & ", " & _
Convert_DateUS_Short(Nz(Me.E_Jour4, Date)) & ", " & Convert_DateUS_Short(Nz(Me.E_Jour5, Date)) & ", " & _
Nz(Me.E_DureeJour, 0) & ", " & Format(Nz((CDate(Me.E_Jour1)), ""), "mmmm") & ", " & "'" & Protected_Quote(Nz(E_EtatDemande, "")) & "', " & _
"'" & Protected_Quote(Nz(E_CommentaireDemandeAnimation, "")) & "', " & Nz(Me.E_ConfirmationCommercial, 0) & ", " & _
Nz(Me.E_ConfirmationSocieteAnimation, 0) & ", " & Nz(Me.E_EntreeSocieteAnimation, 0) & ", " & Nz(Me.E_EntreeMagasin, 0) & ", " & _
Nz(Me.E_SocieteAnimation, 0) & ", " & "'" & Protected_Quote(Nz(E_NomAnimateur, "")) & "', " & Nz(E_EstimationFacture.Caption, 0) & ", " & _
"'" & Protected_Quote(Nz(E_ReferenceFacture, "")) & "', " & Replace(Nz(E_FactureMontant, 0), ",", ".") & ", " & _
Convert_DateUS_Short(Nz(E_DateValidationFacture, Date)) & ", " & Nz(NumAnSem00(CDate(E_DateValidationFacture)), 0) & ", " & _
"'" & Protected_Quote(Nz(E_CommentaireGlobal, "")) & "' " & _
")" |
Partager