1 2 3 4 5 6 7 8 9 10 11
| Private Sub Commande27_Click()
Dim sql As String
sql = "INSERT INTO personnel (Nom,prenom,fonction,id_car,date_autorisation_conduite,date_caces_cariste,date_formation,date_suivi_medical,id_carnac,date_caces_nacelle,date_autorisation_nacelle) VALUES ('" & Forms!ajouter.Nom & "','" & Forms!ajouter.prenom & "','" & Forms!ajouter.fonction & "'," & Forms!ajouter.cariste & ", #" & Nz(Forms!ajouter.Autoristaion_conduite) & "#, #" & Nz(Forms!ajouter.CACES) & "#,#" & Nz(Forms!ajouter.Formation) & "#,#" & Nz(Forms!ajouter.Visitemed) & "#, " & Forms!ajouter.cariste_nacelle & ",#" & Nz(Forms!ajouter.CACES_nacelle) & "#,#" & Nz(Forms!ajouter.Autorisation_nacelle) & "#);"
Me.CACES.SetFocus
Me.CACES_nacelle.SetFocus
Me.Formation.SetFocus
Me.Autorisation_nacelle.SetFocus
Me.Autoristaion_conduite.SetFocus
DoCmd.RunSQL sql
End Sub |
Partager