1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| DoCmd.SetWarnings False 'Permet de ne pas afficher les messages
Dim stDocName As String
Dim stDocName1 As String
Dim stdocname2 As String
stDocName = "r_save_cmd"
stDocName1 = "r_del_cmd"
stdocname2 = "r_maj_stock_auto"
stDocName3 = "r_del_cmd_boitier"
DoCmd.OpenQuery stdocname2, acNormal, acEdit 'MISE A JOUR DES STOCKS
DoCmd.OpenQuery stDocName, acNormal, acEdit 'SAVE CMD DANS LA TABLE T_RADIATEURS
If IsNull([Forms]![f_cmd_encours2]![côté]) Then
DoCmd.OpenQuery stDocName3, acNormal, acEdit 'SUPPRESSION DE LA CMD A PREPARER
Else
DoCmd.OpenQuery stDocName1, acNormal, acEdit 'SUPPRESSION DE LA CMD A PREPARER
End If
[f_cmd_encours2].Requery 'met a jour l'affichage du formulaire |
Partager