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
| Option Compare Database
Option Explicit
Dim Offset As Single
Dim X01 As Single
Dim X02 As Single
Dim X03 As Single
Dim X04 As Single
Dim X05 As Single
Dim X06 As Single
Dim X07 As Single
Dim X08 As Single
Dim X09 As Single
Dim X10 As Single
Dim X11 As Single
Dim X12 As Single
Private Sub Détail_Print(Cancel As Integer, PrintCount As Integer)
'Offset = 600 / Me.GridX ' Convertit Grille X en twips
Offset = 0 / Me.GridX ' Convertit Grille X en twips
X01 = [Clé_Alpha].Left - Offset ' Calcule X01 en twips
Me.Line (X01, 0)-(X01, 10000) ' Dessine la ligne verticale
X02 = [Clé_Désignation].Left - Offset
Me.Line (X02, 0)-(X02, 10000)
X03 = [Clé_Contenu].Left - Offset
Me.Line (X03, 0)-(X03, 10000)
X04 = [Clé_Administration].Left - Offset
Me.Line (X04, 0)-(X04, 10000)
X05 = [Clé_BS].Left - Offset
Me.Line (X05, 0)-(X05, 10000)
X06 = [Clé_Restaurant].Left - Offset
Me.Line (X06, 0)-(X06, 10000)
X07 = [Clé_RSA].Left - Offset
Me.Line (X07, 0)-(X07, 10000)
X08 = [Clé_Jardin].Left - Offset
Me.Line (X08, 0)-(X08, 10000)
X09 = [Clé_Sport].Left - Offset
Me.Line (X09, 0)-(X09, 10000)
X10 = [Clé_Bus de nuit].Left - Offset
Me.Line (X10, 0)-(X10, 10000)
X11 = [Clé_Logements Soleil].Left - Offset
Me.Line (X11, 0)-(X11, 10000)
X12 = [Clé_Logements Soleil].Left + [Clé_Logements Soleil].Width - Offset
Me.Line (X12, 0)-(X12, 10000)
End Sub |
Partager