1 2 3 4 5 6 7 8 9
| R_Sql = "UPDATE [t_formation] SET [t_formation].JourForm = " & Convert_DateUS_Short(Nz(Me.JourForm, Date)) & _
", [t_formation].Famille = " & Nz(Famille, "") & _
", [t_formation].Theme = " & Nz(Theme, "") & _
", [t_formation].NumForm = '" & Nz(NumForm, "") & "' " & _
", [t_formation].DureeForm = " & Convert_Time(Nz(DureeForm, "00:00:00")) & _
", [t_formation].FMPA = " & Nz(Theme, 0) & _
", [t_formation].Formateur = " & Nz(Formateur, "") & _
", [t_formation].Observation = '" & Protected_Quote(Nz(Observation, "")) & "' "
R_Sql = R_Sql & "WHERE ((([t_formation].ID_Formation)=" & Nz(Me.ID_Formation, 0) & "));" |
Partager