Well here is the code. Messier then all get out but I'm just now learning VB so getting scraps from here and there.
Private Sub Form_Load()
'Lock All Data Controls except SearchBox
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Name <> "SearchBox" Then
If TypeOf ctl Is TextBox Or TypeOf ctl Is ComboBox Or TypeOf ctl Is ListBox _
Or TypeOf ctl Is CheckBox Then
ctl.Enabled = False
ctl.Locked = True
End If
End If
Next ctl
End Sub
Private Sub SearchButton_Click()
Dim rs As Object
If Not IsNull(Me.SearchBox) Then
Set rs = Me.Recordset.Clone
rs.FindFirst "[StudentID] = '" & Me![SearchBox] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
If rs.NoMatch Then MsgBox "No Match Found!"
Else
MsgBox "You Must Enter An ID Number Before Searching!"
End If
End Sub
Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button1.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonUpLeft.gif"
button2.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonUpLeft.gif"
button3.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonUpLeft.gif"
button6.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonUpRight.gif"
button7.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonUpRight.gif"
button8.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonUpRight.gif"
button9.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonUpLeft.gif"
button10.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonUpLeft.gif"
Button11.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonUpRight.gif"
button12.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonUpRight.gif"
information.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\infoUp.gif"
check.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\checkUp.gif"
hourGlass.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\hourglassUp.gif"
mail.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\mailUp.gif"
saveFile.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\saveUp.gif"
logoLink.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\logoUp.jpg"
menuLast.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuLastUp.gif"
menuFirst.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuFirstUp.gif"
menuNext.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuNextUp.gif"
menuPrevious.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuPreviousUp.gif"
menuFind.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuSearchUp.gif"
SearchButton.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\searchButtonUp.gif"
End Sub
Private Sub button1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button1.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonDownLeft.gif"
End Sub
Private Sub button1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button1.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonOverLeft.gif"
End Sub
Private Sub button10_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button10.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonDownLeft.gif"
End Sub
Private Sub button10_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button10.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonOverLeft.gif"
End Sub
Private Sub Button11_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Button11.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonDownRight.gif"
End Sub
Private Sub button11_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Button11.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonOverRight.gif"
End Sub
Private Sub button12_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button12.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonDownRight.gif"
End Sub
Private Sub button12_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button12.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonOverRight.gif"
End Sub
Private Sub button2_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button2.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonDownLeft.gif"
End Sub
Private Sub button2_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button2.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonOverLeft.gif"
End Sub
Private Sub button3_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button3.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonDownLeft.gif"
End Sub
Private Sub button3_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button3.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonOverLeft.gif"
End Sub
Private Sub button4_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button4.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonDownLeft.gif"
End Sub
Private Sub button4_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button4.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonOverLeft.gif"
End Sub
Private Sub Button5_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Button5.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonDownRight.gif"
End Sub
Private Sub button5_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Button5.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonOverRight.gif"
End Sub
Private Sub button6_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button6.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonDownRight.gif"
End Sub
Private Sub button6_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button6.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonOverRight.gif"
End Sub
Private Sub button7_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button7.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonDownRight.gif"
End Sub
Private Sub button7_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button7.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonOverRight.gif"
End Sub
Private Sub button8_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button8.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonDownRight.gif"
End Sub
Private Sub button8_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button8.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\ButtonOverRight.gif"
End Sub
Private Sub button9_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
button9.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonDownLeft.gif"
End Sub
Private Sub button9_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
button9.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\BottomButtonOverLeft.gif"
End Sub
Private Sub check_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
check.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\checkDown.gif"
End Sub
Private Sub check_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
check.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\checkOver.gif"
End Sub
Private Sub hourGlass_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
hourGlass.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\hourglassDown.gif"
End Sub
Private Sub hourGlass_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
hourGlass.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\hourglassOver.gif"
End Sub
Private Sub information_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
information.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\infoDown.gif"
End Sub
Private Sub information_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
information.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\infoOver.gif"
End Sub
Private Sub logoLink_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
logoLink.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\logoDown.jpg"
End Sub
Private Sub logoLink_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
logoLink.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\logoOver.jpg"
End Sub
Private Sub mail_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
mail.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\mailDown.gif"
End Sub
Private Sub mail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
mail.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\mailOver.gif"
End Sub
Private Sub menuFind_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuFind.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuSearchDown.gif"
End Sub
Private Sub menuFind_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuFind.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuSearchOver.gif"
End Sub
Private Sub menuFirst_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuFirst.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuFirstDown.gif"
End Sub
Private Sub menuFirst_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuFirst.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuFirstOver.gif"
End Sub
Private Sub menuLast_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuLast.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuLastDown.gif"
End Sub
Private Sub menuLast_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuLast.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuLastOver.gif"
End Sub
Private Sub menuNext_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuNext.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuNextDown.gif"
End Sub
Private Sub menuNext_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuNext.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuNextOver.gif"
End Sub
Private Sub menuPrevious_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuPrevious.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuPreviousDown.gif"
End Sub
Private Sub menuPrevious_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
menuPrevious.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\menuPreviousOver.gif"
End Sub
Private Sub saveFile_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
saveFile.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\saveDown.gif"
End Sub
Private Sub saveFile_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
saveFile.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\saveOver.gif"
End Sub
Private Sub SearchButton_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
SearchButton.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\searchButtonDown.gif"
End Sub
Private Sub SearchButton_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
SearchButton.Picture = "C:\Users\Morgandy\Desktop\SASHA\images\searchButtonOver.gif"
End Sub