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
| Private Sub Form_Load()
Select Case OpenArgs
Case "moyens_prod"
Nouv_N°_moy = DMax("N°moyen_prod", "Moyens_Prod", "N°moyen_prod < 1000") + 1
DoCmd.MoveSize 8000, 4000
Case "process"
Nouv_N°_moy = DMax("N°moyen_prod", "Moyens_Prod") + 1
DoCmd.MoveSize 8000, 4000
Case "DupliquerProcess"
Nouv_N°_moy = DMax("N°moyen_prod", "Moyens_Prod") + 1
DoCmd.MoveSize 8000, 4000
Case Else
End Select
End Sub
Private Sub OK_Click()
On Error GoTo Fin
Select Case OpenArgs
Case "moyens_prod"
DoCmd.SetWarnings False
DoCmd.OpenQuery "Ajoute_moyen"
DoCmd.SetWarnings True
Forms!moyens_prod.Filter = "N°moyen_prod = " & Nouv_N°_moy
Case "process"
DoCmd.SetWarnings False
DoCmd.OpenQuery "Ajoute_process"
DoCmd.SetWarnings True
Forms!process.Filter = "N°moyen_prod = " & Nouv_N°_moy
Case "DupliquerProcess"
DoCmd.SetWarnings False
DoCmd.OpenQuery "Duplique_process"
DoCmd.SetWarnings True
Forms!process.Filter = "N°moyen_prod = " & Nouv_N°_moy
Case Else
End Select
Fin:
DoCmd.Close
End Sub |
Partager