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 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
| Option Compare Database
Private Sub Commande41_Click()
Dim oRst As DAO.Recordset
Dim enrg As String
If Me.NewRecord Then
engr = MsgBox("Veillez confirmer l'enregistrement", vbExclamation + vbYesNo + 0, "Confirmation")
If engr = vbYes Then
Set oRst = CurrentDb.OpenRecordSet("SELECT Max(INDICEOM) FROM ORDRE_DE_MISSION WHERE Format(DATEDEBOM,""yy"")=" & Chr(34) & Format(Me.DATEDEBOM, "yy") & Chr(34))
If Me.MATOM > 0 Then
Me.MATOM.Enabled = False
Me.SAOM.Enabled = False
Me.LIEUOM.Enabled = False
Me.MOYENTRSP.Enabled = False
Me.DATEDEBOM.Enabled = False
Me.DATEFINOM.Enabled = False
Me.OMPTION.Enabled = False
Me.MOTIFSOM.Enabled = False
Me.RESULTOM.Enabled = False
Else
Me.MATOM.Enabled = True
Me.SAOM.Enabled = True
Me.LIEUOM.Enabled = True
Me.MOYENTRSP.Enabled = True
Me.DATEDEBOM.Enabled = True
Me.DATEFINOM.Enabled = True
Me.OMPTION.Enabled = True
Me.MOTIFSOM.Enabled = True
Me.RESULTOM.Enabled = True
End If
With oRst
If Not .EOF Then
Me![INDICEOM].Value = Nz(.Fields(0).Value, 0) + 1
Else
Me![INDICEOM].Value = 1
End If
.Close
End With
End If
NUMOM = Format(Me.INDICE, "000")
End If
Dim impres
impres = MsgBox("Voullez vous imprimer le document en cours", vbInformation + vbYesNo + 256, "Impression")
If impres = vbYes Then
DoCmd.RefreshRecord
DoCmd.OpenReport "ETAT ORDRE DE MISSION", acViewNormal, "", "", acNormal
End If
End Sub
Private Sub Commande42_Click()
Dim Sup
Sup = MsgBox("Veuillez confirmer la suppression du fichier!", vbCritical + vbYesNo + 256, "Attention")
If Sup = vbYes Then
DoCmd.RunCommand acCmdDeleteRecord
MsgBox "Suppression confirmée!"
DoCmd.RunCommand acCmdRecordsGoToLast
End If
End Sub
Private Sub DATEFINOM_AfterUpdate()
NBRJOM = (DATEFINOM - DATEDEBOM) + 1
DATEDEPOM = DATEDEBOM
End Sub
Private Sub Form_Current()
If Me.MATOM > 0 Then
Me.MATOM.Enabled = False
Me.SAOM.Enabled = False
Me.LIEUOM.Enabled = False
Me.MOYENTRSP.Enabled = False
Me.DATEDEBOM.Enabled = False
Me.DATEFINOM.Enabled = False
Me.OMPTION.Enabled = False
Me.MOTIFSOM.Enabled = False
Me.RESULTOM.Enabled = False
Else
Me.MATOM.Enabled = True
Me.SAOM.Enabled = True
Me.LIEUOM.Enabled = True
Me.MOYENTRSP.Enabled = True
Me.DATEDEBOM.Enabled = True
Me.DATEFINOM.Enabled = True
Me.OMPTION.Enabled = True
Me.MOTIFSOM.Enabled = True
Me.RESULTOM.Enabled = True
End If
End Sub
Private Sub MATOM_AfterUpdate()
AGENTOM = NOM
SCEOM = SERVICE
FONCTOM = FOCNTIONS
CATOM = CATEGORIE
SAOM = SA
End Sub
Private Sub MOTIFSOM_AfterUpdate()
RESULTOM = "Mission accomplie"
End Sub |
Partager