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 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134
| Option Compare Database
Private Sub Aperçu_du_document_Click()
On Error GoTo Err_Aperçu_du_document_Click
Dim stDocName As String
stDocName = "Moulin"
DoCmd.OpenReport stDocName, acPreview
Exit_Aperçu_du_document_Click:
Exit Sub
Err_Aperçu_du_document_Click:
MsgBox Err.Description
Resume Exit_Aperçu_du_document_Click
End Sub
Private Sub Commande116_Click()
Me.FicheTerrainPdf = Me.PARAM & CStr(Me.N_ACCESS) & ".pdf"
End Sub
Private Sub Form_Current()
Me.Modifiable90 = Me.N_ACCESS
Me.Modifiable94 = Me.INSEEMOULIN
Me.Liste100.Requery
Me.Liste100 = Me.N_ACCESS
Me.Modifiable103 = Me.BV
Me.Liste109.Requery
Me.Liste109 = Me.N_ACCESS
End Sub
Private Sub Modifiable103_AfterUpdate()
Me.Liste109.Requery
End Sub
Private Sub Modifiable90_AfterUpdate()
' Rechercher l'enregistrement correspondant au contrôle.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[N_ACCESS] = " & Str(Me![Modifiable90])
Me.Bookmark = rs.Bookmark
End Sub
Private Sub Modifiable98_AfterUpdate()
' Rechercher l'enregistrement correspondant au contrôle.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[N_ACCESS] = " & Str(Me![Modifiable98])
Me.Bookmark = rs.Bookmark
End Sub
Private Sub Liste100_AfterUpdate()
' Rechercher l'enregistrement correspondant au contrôle.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[N_ACCESS] = " & Str(Me![Liste100])
Me.Bookmark = rs.Bookmark
End Sub
Private Sub Modifiable94_AfterUpdate()
Me.Liste100.Requery
End Sub
Private Sub Liste105_AfterUpdate()
' Rechercher l'enregistrement correspondant au contrôle.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[N_ACCESS] = " & Str(Me![Liste105])
Me.Bookmark = rs.Bookmark
End Sub
Private Sub Liste109_AfterUpdate()
' Rechercher l'enregistrement correspondant au contrôle.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[N_ACCESS] = " & Str(Me![Liste109])
Me.Bookmark = rs.Bookmark
End Sub
Private Sub Commande117_Click()
On Error GoTo Err_Commande117_Click
DoCmd.GoToRecord , , acNewRec
Exit_Commande117_Click:
Exit Sub
Err_Commande117_Click:
MsgBox Err.Description
Resume Exit_Commande117_Click
End Sub
Private Sub Commande118_Click()
On Error GoTo Err_Commande118_Click
DoCmd.GoToRecord , , acNewRec
Exit_Commande118_Click:
Exit Sub
Err_Commande118_Click:
MsgBox Err.Description
Resume Exit_Commande118_Click
End Sub
Private Sub Commande119_Click()
On Error GoTo Err_Commande119_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Exit_Commande119_Click:
Exit Sub
Err_Commande119_Click:
MsgBox Err.Description
Resume Exit_Commande119_Click
End Sub |
Partager