MS Access Code was working but now gives error message. Please kindly help. Thanks a lot

Hi Supers
Attached are the codes with error. These codes were fine did not give me any error, now it does.
Thanks a lot
-------

Option Compare Database

Private Sub ExitBtn_Click()

    If MsgBox("Are you sure you want to exit?", vbQuestion + vbYesNo, "Quit Program") = vbNo Then
        Cancel = True
    Else
    DoCmd.Quit
    
    End If

End Sub

Private Sub Form_Load()
   username = Environ("COMPUTERNAME") & "." & Environ("USERNAME")
   DoCmd.SetWarnings False
   DoCmd.OpenQuery "LogOnQ"
   DoCmd.SetWarnings True
End Sub

Private Sub Form_Open(Cancel As Integer)

      DoCmd.Maximize

End Sub

Private Sub Form_Unload(Cancel As Integer)
   DoCmd.SetWarnings False
   DoCmd.OpenQuery "LogOffQ"
   DoCmd.SetWarnings True
End Sub

Thanks

thanks a lot Sandy.
Code that has error (never had error before)

Option Compare Database

Private Sub ExitBtn_Click()

    If MsgBox("Are you sure you want to exit?", vbQuestion + vbYesNo, "Quit Program") = vbNo Then
        Cancel = True
    Else
    DoCmd.Quit
    
    End If

End Sub

Private Sub Form_Load()
   username = Environ("COMPUTERNAME") & "." & Environ("USERNAME")
   DoCmd.SetWarnings False
   DoCmd.OpenQuery "LogOnQ"
   DoCmd.SetWarnings True
End Sub

Private Sub Form_Open(Cancel As Integer)

      DoCmd.Maximize

End Sub

Private Sub Form_Unload(Cancel As Integer)
   DoCmd.SetWarnings False
   DoCmd.OpenQuery "LogOffQ"
   DoCmd.SetWarnings True
End Sub

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

However, if you continue to not use code tags, you can expect to have your thread BLOCKED until you add them yourself.

What is the error and on which line(s)?