3
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by santosh5471
0

Hi anku123,
For your combobox related problem see my attached help. And for your second question I would suggest the following code.

'checks if txtMark is between 0 and 100
If txtMark > 100 Or txtMark < 0 Then
'displays message
MsgBox "Marks should be between 0 and 100, please type again.", vbOKOnly, "Invalid Entry"
'clears data in txtMark
txtMark = ""
'set focus to txtMark
txtMark.SetFocus
Else
End If

Hope this helps

0

If you are keeping the data of various courses in a Master you can keep the number of semesters with the Name as below
Course_Name Course_Sems
M.C.A 6
M.B.A 4
B.C.A 2
B.E. 8 Likewise....

Now depending upon the no. of sems you can ENABLED = TRUE OR FALSE the Marks Text Box


Try it ... Good Luck

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.