Compile error: Method or data member not found

[Michael515]

Hi,

I am trying to create a simple login button and have cross referenced my code across a couple web pages and it all seems to check yet I still get a Compile error: method or data member not found. Any thoughts?

Private Sub LoginButton_Click()
If Me.Username.Value = "Admin" Then
    If Me.Password.Value = "1234" Then
        LoginFlag = True
        Unload Me
        Exit Sub
    End If
End If
MsgBox "Sorry, you are not an authorized user"
End Sub
 
Private Sub Worksheet_Activate()
If LoginFlag = False Then
    Worksheet(1).Activate
    Login.Show
End If
End Sub

 

[RoryA]

When you type Me. in the code, do you see Username in the list of available Intellisense items after typing the full stop?

 

[dmt32]

Are you referring to the line item in the properties of the Username field as in (Name)? Or are you referring to what we actually typed into the username field area?

Is the "UserName Field" a TextBox in your UserForm Named "UserName"? same with "Password"

Dave

 

[Michael515]

When I typed the Me., username did pop up, but after typing username, value did not pop up, so I'm guessing that is were the problem lies.

 

[Michael515]

I figured it out y'all. The reason the .value field was not auto-populating was because the Username box was referring to the label username and not the textbox where you actually typed in the username. My code should have read

Private Sub LoginButton_Click()
IF Me.Textbox1.Value = "Admin"

Instead of

Private Sub LoginButton_Click()
IF Me.Username.Value = "Admin"

Thanks for the help guys. The constant flow of ideas kept me thinking and eventually I figured out why the .value was appearing. If it wasn't for your questions, I would not have thought critically enough and stumbled upon my mistake! Thank you all for your time and help!