1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
Private Sub BTN_AjoutGroupe_Click()
' Code pour Requete SQL
Dim rsql As String
Set db = CurrentDb
'Analyse de la date : correction du bug qui inverse jour et mois si le jour est <=12
Dim Jour As String
Dim Mois As String
Dim Annee As String
Dim Var As String
If Day(SAI_DateDeb.Value) <= 12 Then
Jour = Day(SAI_DateDeb.Value)
Mois = Month(SAI_DateDeb.Value)
Annee = Year(SAI_DateDeb.Value)
Var = Mois & "/" & Jour & "/" & Annee
rsql = "INSERT INTO GROUPE (NomGroupe, DescriptionGroupe, DateDeb, DateFin,Id_Formation) VALUES ('" & SAI_NomGroupe.Value & "', '" & SAI_DescGroupe.Value & "', #" & Var & "#, #" & SAI_DateFin.Value & "#, " & LD_For.Column(0, LD_For.ItemsSelected) & ")"
Else
rsql = "INSERT INTO GROUPE (NomGroupe, DescriptionGroupe, DateDeb, DateFin,Id_Formation) VALUES ('" & SAI_NomGroupe.Value & "', '" & SAI_DescGroupe.Value & "', #" & CDate(Format(SAI_DateDeb.Value, "dd/mm/yyyy")) & "#, #" & SAI_DateFin.Value & "#, " & LD_For.Column(0, LD_For.ItemsSelected) & ")"
End If
' Execution de la requete
db.Execute (rsql) |
Partager