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
| Option Compare Database
Option Explicit
Private Type ch_DEVMODE
RGB As String * 94
End Type
Private Type type_DEVMODE
entOrientation As Integer
entTaillePapier As Integer
End Type
Private Sub Commande0_Click()
'Déclaration des variables
Dim MonEtat As String
Dim ChaînePér As ch_DEVMODE
Dim DM As type_DEVMODE
Dim chExtraModPér As String
Dim rpt As Report
MonEtat = "E_Planning_TESTDimension"
DoCmd.OpenReport MonEtat, acDesign
'MonEtat = Me.OnOpen
Set rpt = Reports(MonEtat)
If Not IsNull(rpt.PrtDevMode) Then
chExtraModPér = rpt.PrtDevMode
ChaînePér.RGB = chExtraModPér
LSet DM = ChaînePér
'DM.lngChamps = DM.lngChamps Or DM.entOrientation ' Initialise les champs.
MsgBox (DM.entTaillePapier)
DM.entTaillePapier = 8
End If
LSet ChaînePér = DM ' Met à jour la propriété.
Mid(chExtraModPér, 1, 94) = ChaînePér.RGB
rpt.PrtDevMode = chExtraModPér
DoCmd.Close acReport, MonEtat, acSaveYes
DoCmd.OpenReport MonEtat, acViewPreview
MsgBox (DM.entTaillePapier)
End Sub |
Partager