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
| Option Compare Database
Option Explicit
Dim varAmt As Single
Dim varTotal As Single
Private Sub bsl1_Click()
If Me.bsl1 Then
Me.txtetape_1_1_.BackColor = 11592637
varAmt = varAmt + 1
Call PctMeter(varAmt, varTotal)
Else
Me.txtetape_1_1_.BackColor = -2147483643
varAmt = varAmt - 1
Call PctMeter(varAmt, varTotal)
End If
Me.txtetape_1_1_.Requery
End Sub
Private Sub bsl2_Click()
If Me.bsl2 Then
Me.txtetape_1_2_.BackColor = 11592637
varAmt = varAmt + 1
Call PctMeter(varAmt, varTotal)
Else
Me.txtetape_1_2_.BackColor = -2147483643
varAmt = varAmt - 1
Call PctMeter(varAmt, varTotal)
End If
Me.txtetape_1_2_.Requery
End Sub
Private Sub bsl3_Click()
If Me.bsl3 Then
Me.txtetape_1_3_.BackColor = 11592637
varAmt = varAmt + 1
Call PctMeter(varAmt, varTotal)
Else
Me.txtetape_1_3_.BackColor = -2147483643
varAmt = varAmt - 1
Call PctMeter(varAmt, varTotal)
End If
Me.txtetape_1_3_.Requery
End Sub
Private Sub bsl4_Click()
If Me.bsl4 Then
Me.txtetape_1_4_.BackColor = 11592637
varAmt = varAmt + 1
Call PctMeter(varAmt, varTotal)
Else
Me.txtetape_1_4_.BackColor = -2147483643
varAmt = varAmt - 1
Call PctMeter(varAmt, varTotal)
End If
Me.txtetape_1_4_.Requery
End Sub
Private Sub bsl5_Click()
If Me.bsl5 Then
Me.txtetape_1_5_.BackColor = 11592637
varAmt = varAmt + 1
Call PctMeter(varAmt, varTotal)
Else
Me.txtetape_1_5_.BackColor = -2147483643
varAmt = varAmt - 1
Call PctMeter(varAmt, varTotal)
End If
Me.txtetape_1_5_.Requery
End Sub
Private Sub bsl6_Click()
If Me.bsl6 Then
Me.txtetape_1_6_.BackColor = 11592637
varAmt = varAmt + 1
Call PctMeter(varAmt, varTotal)
Else
Me.txtetape_1_6_.BackColor = -2147483643
varAmt = varAmt - 1
Call PctMeter(varAmt, varTotal)
End If
Me.txtetape_1_6_.Requery
End Sub
Private Sub Form_Load()
Me.txtetape_1_1_.BackColor = -2147483643
Me.txtetape_1_2_.BackColor = -2147483643
Me.txtetape_1_3_.BackColor = -2147483643
Me.txtetape_1_4_.BackColor = -2147483643
Me.txtetape_1_5_.BackColor = -2147483643
Me.txtetape_1_6_.BackColor = -2147483643
End Sub
Public Function PctMeter(varAmt As Variant, varTotal As Variant)
Dim sngPct As Single
varTotal = 36
sngPct = varAmt / varTotal
If sngPct <= 1 Then
Me!baselbl.Caption = Int(sngPct * 100) & "%"
Me!lblmeter.Width = CLng(Me!baselbl.Width * sngPct)
Else
Me!baselbl.Caption = "Greater than 100% - Check your amounts"
Me!lblmeter.Width = CLng(Me!baselbl.Width * 1)
End If
Select Case sngPct
Case Is < 0.15
Me!lblmeter.BackColor = 255
Case Is < 0.5
Me!lblmeter.BackColor = 65535
Case Else
Me!lblmeter.BackColor = 65280
End Select
End Function |
Partager