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
|
Private Sub Commande62_Click()
'""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Dim bd As DAO.Database
Dim RecSet, rs As DAO.Recordset
Dim var_DM As String
Dim var_Option As Boolean
Dim csql5, csql6, csql7, cSQL As String
Dim Var_succes As Integer
Set bd = CurrentDb
Set RecSet = bd.OpenRecordset("TAB_Insertions_Hist", dbOpenTable)
Me.Étiquette74.Visible = True
Texte60.Visible = False
Texte36.Visible = False
Texte6.Visible = False
Texte27.Visible = False
Texte11.Visible = False
Étiquette37.Visible = False
Étiquette8.Visible = False
Modifiable64.Visible = False
RecSet.index = "N°Insertion" 'Vérifier si l'Insertion n'est pas déjà existante dans la Table TAB_Insertions_Hist cloturée en échec
RecSet.Seek "=", Me.Texte36.Value
If Not (RecSet.NoMatch) And Not IsNull(val(Me.Texte36)) Then 'si je la trouve dans la Table TAB_Insertions_Hist
csql7 = "delete from [TAB_Insertions_Hist] "
csql7 = csql7 & "where TAB_Insertions_Hist.N°Insertion ='" & Me.Texte36.Value & "'"
DoCmd.RunSQL csql7
End If
'ICI le code de l'Insertion dans la table TAB_Insertions_Hist
csql5 = "insert into [TAB_Insertions_Hist] ([N°Insertion],[Num_Archives],[DATE_Cloture],[ID_Op],[Succes])" & _
"values ("
csql5 = csql5 & Chr(34) & Texte36.Value & Chr(34) ' N° Insertion (Numérique)
csql5 = csql5 & "," & "'" & Texte6.Value & "'" ' N° Dossier (Texte)
csql5 = csql5 & ",#" & Format(DATE, "MM/DD/YYYY") & "#" '[DATE_Cloture]
csql5 = csql5 & "," & Chr(34) & Modifiable64.Value & Chr(34) 'Opérateur Texte
csql5 = csql5 & "," & Option75.Value ' Succes OUI (-1)/NON (0)
csql5 = csql5 & ");"
DoCmd.RunSQL csql5
Forms!F_Insert.Sous_Formulaire_Insertions.Form.RecordSource = Forms!F_Insert.Sous_Formulaire_Insertions.Form.RecordSource
DoCmd.Requery
If Me.Option75 = -1 Then ' Si Cloture en succes
DoCmd.RunCommand acCmdSaveRecord
csql6 = "delete from [TAB_Insertions] "
csql6 = csql6 & "where TAB_Insertions.N°Insertion ='" & Me.Texte36.Value & "'"
DoCmd.RunSQL csql6
Forms!F_Insert.Form.Refresh 'Formulaire Insertions
Forms!F_Insert.Sous_Formulaire_Insertions.Form.Refresh 'Sous Formulaire Insertions
Forms!F_Insert.Sous_Formulaire_Insertions.Form.RecordSource = Source
Else
Me.Form.Requery 'ici pb Form_F_Insert_Clot
Forms!F_Insert.Sous_Formulaire_Insertions.Form.Refresh 'Sous Formulaire Insertions
End If
Texte60.Visible = False
Texte36.Visible = False
Texte6.Visible = False
Texte27.Visible = False
Texte11.Visible = False
Étiquette37.Visible = False
Étiquette8.Visible = False
Étiquette65.Visible = False
Modifiable64.Visible = False
End Sub |
Partager