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 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187
| Option Compare Database
Function Barre_Edition_Fichier__Fermer(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier__Fermer_Err
Dim MonEtat As Report
' récupération de l'état actif dans la variable MonEtat
Set MonEtat = Screen.ActiveReport
If EstEtat() Then
'DoCmd.RunCommand acCmdClose(MonEtat.Name)
DoCmd.Close acReport, MonEtat.Name, acSaveYes
End If
'
Barre_Edition_Fichier__Fermer_Exit:
Exit Function
Barre_Edition_Fichier__Fermer_Err:
If Err = 2476 Then Resume Next
MsgBox Error$
Resume Barre_Edition_Fichier__Fermer_Exit
End Function
Function Barre_Edition_Fichier__Imprimer_(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier__Imprimer__Err
If (EstEtat()) Then
'
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.Echo True, "En cours Impression " & Screen.ActiveReport.Name & "..."
DoCmd.PrintOut A_PRINTALL, , , A_HIGH, 1
DoCmd.Close A_REPORT, Screen.ActiveReport.Name
End If
Barre_Edition_Fichier__Imprimer__Exit:
Exit Function
Barre_Edition_Fichier__Imprimer__Err:
If Err = 2501 Then Resume Next
MsgBox Error$, vbCritical, "Optimum Classic"
Resume Barre_Edition_Fichier__Imprimer__Exit
End Function
Function Barre_Edition_Fichier_Confi_guration_de_l_imprimante___(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier_Confi_guration_de_l_imprimante____Err
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
'
DoCmd.RunCommand acCmdPageSetup
Exit Function
Barre_Edition_Fichier_Confi_guration_de_l_imprimante____Exit:
MsgBox Err.Description
Exit Function
'
Barre_Edition_Fichier_Confi_guration_de_l_imprimante____Err:
If Err = 2501 Then Resume Next
MsgBox Error$
Resume Barre_Edition_Fichier_Confi_guration_de_l_imprimante____Exit
End Function
Function Barre_Edition_Fichier_Imprimer_avec__Options___(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier_Imprimer_avec__Options____Err
'
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdPrint
Barre_Edition_Fichier_Imprimer_avec__Options____Exit:
Exit Function
Barre_Edition_Fichier_Imprimer_avec__Options____Err:
If Err = 2501 Then Resume Next
MsgBox Error$
Resume Barre_Edition_Fichier_Imprimer_avec__Options____Exit
End Function
Function Barre_Edition_Fichier_Export_de_l_imprimante___(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier_Export_de_l_imprimante___Err
'
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdExportExcel
'
Barre_Edition_Fichier_Export_de_l_imprimante____Exit:
Exit Function
Barre_Edition_Fichier_Export_de_l_imprimante___Err:
MsgBox Error$, vbCritical, "Optimum Classic"
Resume Barre_Edition_Fichier_Export_de_l_imprimante____Exit
End Function
Function Barre_Edition_Fichier_WORD_de_l_imprimante___(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier_WORD_de_l_imprimante___Err
'
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdExportRTF
Barre_Edition_Fichier_WORD_de_l_imprimante____Exit:
Exit Function
Barre_Edition_Fichier_WORD_de_l_imprimante___Err:
MsgBox Error$, vbCritical, "Optimum Classic"
Resume Barre_Edition_Fichier_WORD_de_l_imprimante____Exit
End Function
Function Barre_Edition_Fichier_PDF_de_l_imprimante___(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier_PDF_de_l_imprimante___Err
Dim MonEtat As Report
' récupération de l'état actif dans la variable MonEtat
Set MonEtat = Screen.ActiveReport
If EstEtat() Then
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.OutputTo acOutputReport, MonEtat.Name, acFormatPDF, CurrentDBDir & MonEtat.Name & ".pdf", False
'
MsgBox "Export réussi sous " & vbCrLf & CurrentDBDir & MonEtat.Name & ".pdf", vbInformation & vbOKOnly, "Export PDF"
'
End If
'
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
'
Barre_Edition_Fichier_PDF_de_l_imprimante____Exit:
Exit Function
Barre_Edition_Fichier_PDF_de_l_imprimante___Err:
MsgBox Error$, vbCritical, "Optimum Classic"
Resume Barre_Edition_Fichier_PDF_de_l_imprimante____Exit
End Function
Function Barre_Edition_Fichier_Maxi(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier_Maxi_Err
Dim MonEtat As Report
' récupération de l'état actif dans la variable MonEtat
Set MonEtat = Screen.ActiveReport
If EstEtat() Then
'DoCmd.RunCommand acCmdClose(MonEtat.Name)
'
DoCmd.SelectObject acReport, MonEtat.Name, 0
DoCmd.Maximize
End If
'
'DoCmd.Restore
'
Exit Function
'
Barre_Edition_Fichier_Maxi_Exit:
Exit Function
Barre_Edition_Fichier_Maxi_Err:
If Err = 2476 Then Resume Next
MsgBox Error$
Resume Barre_Edition_Fichier_Maxi_Exit
End Function
Function Barre_Edition_Fichier_Mini(ByVal control As IRibbonControl)
On Error GoTo Barre_Edition_Fichier_Mini_Err
Dim MonEtat As Report
' récupération de l'état actif dans la variable MonEtat
Set MonEtat = Screen.ActiveReport
If EstEtat() Then
'DoCmd.RunCommand acCmdClose(MonEtat.Name)
'
DoCmd.SelectObject acReport, MonEtat.Name, 0
DoCmd.Restore
'
'DoCmd.Restore
'
End If
Exit Function
'
Barre_Edition_Fichier_Mini_Exit:
Exit Function
Barre_Edition_Fichier_Mini_Err:
If Err = 2476 Then Resume Next
MsgBox Error$
Resume Barre_Edition_Fichier_Mini_Exit
End Function |
Partager