Hello,
Having a hard time within a new class module I created. It has a property called "CompanyName".
I've set the Get property to public (to expose it outside the class), and the Let property to private (I want to populate this value within the class with another method).
Here's the property:
and here's the code to populate the value:
(recordset code omitted)
It won't compile. VBE highlights the me.companyname and says "Method or Data member not found". Even though it gave me the intellesense when writing it.
Any ideas?
Having a hard time within a new class module I created. It has a property called "CompanyName".
I've set the Get property to public (to expose it outside the class), and the Let property to private (I want to populate this value within the class with another method).
Here's the property:
Code:
Public Property Get CompanyName() As String
' Comments:
' Returns : String
' Created : 09/12/19 09:41 GB
' Modified:
On Error GoTo PROC_ERR
CompanyName = m_strCompanyName
PROC_EXIT:
Exit Property
PROC_ERR:
Err.Raise Err.Number
Resume
End Property
Private Property Let CompanyName(NewValue As String)
' Comments:
' Params : NewValue
' Created : 09/12/19 09:41 GB
' Modified:
On Error GoTo PROC_ERR
m_strCompanyName = NewValue
PROC_EXIT:
Exit Property
PROC_ERR:
Err.Raise Err.Number
Resume
End Property
and here's the code to populate the value:
(recordset code omitted)
Code:
Me.CompanyName = .Fields("NAME")
It won't compile. VBE highlights the me.companyname and says "Method or Data member not found". Even though it gave me the intellesense when writing it.
Any ideas?