method or data member not found

[sandy6078]

I have the following code in the open event

If User.AccessID = 1 Then
      Me.cmdAdmin.Enabled = True
   Else
      Me.cmdAdmin.Enabled = False
End If

I get the error "Method or data member not found" when the form opens. I would very much appreciate some insight.

 

[boblarson]

It would be this line causing you problems:

If User.AccessID = 1 Then

Unless you have created your own TYPE you don't reference AccessID this way. Is AccessID a part of the recordset of the form? If so then it would likely be

If Me!AccessID = 1 Then

 

[sandy6078]

I have a this code along with several others and modules was orignially from a security access database created by richard rensel. The User is from this module.

Public Type UserInfo
ViewID As Integer
AccessID As Integer
Active As Boolean
Password As String
UserID As String
SecurityID As String
End Type

Public User As UserInfo

The code works in his database but when I adapted it to my database I get the error. I am using access 2007 if that makes a difference.

 

[sandy6078]

Something that I noticed; when I deleted and retyped the code, after typing
me.
I was able to capture "cmdAdmin" from the drop down box,
but after the next
"."
the drop down box did not include "Enabled".

 

[boblarson]

There is more to that code than you've shown here and it is important to solving this to see the rest. The type can't populate itself, something is populating those values and then you can access those values but it isn't clear from your post as to how to get to them.

 

[boblarson]

And cmdAdmin is a command button, for sure?

 

[sandy6078]

Well, I was going to type yes cmdAdmin is a command button because I just assumed it was. Lightbulb went off and checked first. It is not, I was so caught up in trying to figure out why the code was not working that I did not check the obvious. No it was not a command button it was a label. Makes me feel like a big goof. Thank you Bob for asking the right question. I really appreciate all the help I have gotten from this forum. By the way, I tested the code with a command button and of course it works perfectly

 

[boblarson]

Yeah, since a label doesn't have an .Enabled property that was why I asked that quesiton. Glad you got it sorted, and don't feel too embarassed - I've done things similar in the past myself.