vbus
July 17th, 2003, 10:58 PM
Hello,
I need help with these:
1. How can I use 'SUM' to total values in text boxes into another textbox in a form?
2. How can I use conditional formatting like Excel in the same Access form. Here's my code, but is not working correctly!
If txt1.text > 95 Then
txt1.backColor = vbGreen
Elseif txt1.text <95 And >85 Then
txt1.backColor = vbYellow
Else
txt1.backColor = vbRed
End If
End Sub
3. Beside a number of textboxes and command buttons, I also have 8 comboboxes with dropdown list that connected to 8 different tables in the dB. When the user enter values in textboxes, how can I save the data to be able to retrieve later?
any help is highly appreciated.
I need help with these:
1. How can I use 'SUM' to total values in text boxes into another textbox in a form?
2. How can I use conditional formatting like Excel in the same Access form. Here's my code, but is not working correctly!
If txt1.text > 95 Then
txt1.backColor = vbGreen
Elseif txt1.text <95 And >85 Then
txt1.backColor = vbYellow
Else
txt1.backColor = vbRed
End If
End Sub
3. Beside a number of textboxes and command buttons, I also have 8 comboboxes with dropdown list that connected to 8 different tables in the dB. When the user enter values in textboxes, how can I save the data to be able to retrieve later?
any help is highly appreciated.