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 27 28 29 30 31 32 33 34 35 36 37 38 39
| Private Sub Commande8_Click()
Dim x1 as String
Dim x2 as String
Dim x3 as String
Dim x4 as String
Dim x5 as String
Dim x6 as String
Dim strSQL as String
x1 = (Forms![F_Ajout Produit]!Texte2)
x2 = (Forms![F_Ajout Produit]!Texte9)
x3 = (Forms![F_Ajout Produit]!Texte11)
x4 = (Forms![F_Ajout Produit]!Texte13)
x5 = (Forms![F_Ajout Produit]!Texte15)
x6 = (Forms![F_Ajout Produit]!Texte17)
strSQL = "INSERT INTO T_Produit ( Nom_Produit, Réf_Type, Détail_Produit, Chemin_Image, Qté_Stock, Unité )VALUES ('" & x1 & "', '" & x2 & "', '" & x3 & "', '" & x4 & "', '" & x5 & "', '" & x6 & "')"
Debug.Print strSQL
DoCmd.RunSQL strSQL
DoCmd.Close acForm, "F_Ajout Produit"
Forms!F_Ajout.Requery
On Error GoTo Err_Commande8_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "F_Ajout"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Commande8_Click:
Exit Sub
Err_Commande8_Click:
MsgBox Err.Description
Resume Exit_Commande8_Click
End Sub |
Partager