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
| Sub Totaux()
Dim soustotal As Single
Dim Reduc, Tot1, Tot2, Tot3, Tot4, Tot5, Tot6, Tot7, Tot8, Tot9, Tot10, Tot11, Tot12, Tot13, Tot14, Tot15, Tot16, Tot17, Tot18, Tot19 As Single
If Me!FormTot1 <> "" Then
Tot1 = Me!FormTot1
End If
If Me!FormTot1 = "" Then
Tot1 = 0
End If
If Me!FormTot2 <> "" Then
Tot2 = Me!FormTot2
End If
If Me!FormTot2 = "" Then
Tot2 = 0
End If
If Me!FormTot3 <> "" Then
Tot3 = Me!FormTot3
End If
If Me!FormTot3 = "" Then
Tot3 = 0
End If
If Me!FormTot4 <> "" Then
Tot4 = Me!FormTot4
End If
If Me!FormTot4 = "" Then
Tot4 = 0
End If
If Me!FormTot5 <> "" Then
Tot5 = Me!FormTot5
End If
If Me!FormTot5 = "" Then
Tot5 = 0
End If
If Me!FormTot6 <> "" Then
Tot6 = Me!FormTot6
End If
If Me!FormTot6 = "" Then
Tot6 = 0
End If
If Me!FormTot7 <> "" Then
Tot7 = Me!FormTot7
End If
If Me!FormTot7 = "" Then
Tot7 = 0
End If
If Me!FormTot8 <> "" Then
Tot8 = Me!FormTot8
End If
If Me!FormTot8 = "" Then
Tot8 = 0
End If
If Me!FormTot9 <> "" Then
Tot9 = Me!FormTot9
End If
If Me!FormTot9 = "" Then
Tot9 = 0
End If
If Me!FormTot10 <> "" Then
Tot10 = Me!FormTot10
End If
If Me!FormTot10 = "" Then
Tot10 = 0
End If
If Me!FormTot11 <> "" Then
Tot11 = Me!FormTot11
End If
If Me!FormTot11 = "" Then
Tot11 = 0
End If
If Me!FormTot12 <> "" Then
Tot12 = Me!FormTot12
End If
If Me!FormTot12 = "" Then
Tot12 = 0
End If
If Me!FormTot13 <> "" Then
Tot13 = Me!FormTot13
End If
If Me!FormTot13 = "" Then
Tot13 = 0
End If
If Me!FormTot14 <> "" Then
Tot14 = Me!FormTot14
End If
If Me!FormTot14 = "" Then
Tot14 = 0
End If
If Me!FormTot15 <> "" Then
Tot15 = Me!FormTot15
End If
If Me!FormTot15 = "" Then
Tot15 = 0
End If
If Me!FormTot16 <> "" Then
Tot16 = Me!FormTot16
End If
If Me!FormTot16 = "" Then
Tot16 = 0
End If
If Me!FormTot17 <> "" Then
Tot17 = Me!FormTot17
End If
If Me!FormTot17 = "" Then
Tot17 = 0
End If
If Me!FormTot18 <> "" Then
Tot18 = Me!FormTot18
End If
If Me!FormTot18 = "" Then
Tot18 = 0
End If
If Me!FormTot19 <> "" Then
Tot19 = Me!FormTot19
End If
If Me!FormTot19 = "" Then
Tot19 = 0
End If
soustotal = Tot1 + Tot2 + Tot3 + Tot4 + Tot5 + Tot6 + Tot7 + Tot8 + Tot9 + Tot10 + Tot11 + Tot12 + Tot13 + Tot14 + Tot15 + Tot16 + Tot17 + Tot18 + Tot19
TxtSt.Value = soustotal
If Me!TxtReduc <> "" Then
Reduc = Me!TxtReduc
Else
Reduc = 0
End If
TxtTTC.Value = Me!TxtSt - Reduc
End Sub |
Partager