Connecting Tech Pros Worldwide Forums | Help | Site Map

Compile Error - Method or Data Member Not Found

Member
 
Join Date: Aug 2007
Posts: 57
#1: Oct 18 '07
Upon trying to compile my db, I get the following error - "Compile Error - Method or Data Member Not Found" and it highlights the .backcolor of the following code

Expand|Select|Wrap|Line Numbers
  1. Private Sub Mentioned_Employee_GotFocus()
  2.  Mentioned_Employee.BackColor = 65535
  3. End Sub
I viewed my references and there are none that says MISSING. These are the ones I do have:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft Word 11.0 Object Library
Microsoft Excel 11.0 Object Library
Micsoft ActiveX DataObjects 2.8 Library

I am running Access 2003 SP3.

Can't figure out which reference I'm missing!

Any help is appreciated!

Thanks

Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#2: Oct 18 '07

re: Compile Error - Method or Data Member Not Found


Assuming Mentioned_Employee is a control (text box, etc) on a form:

Me![Mentioned_Employee].Backcolor

Regards,
Scott
Member
 
Join Date: Aug 2007
Posts: 57
#3: Oct 18 '07

re: Compile Error - Method or Data Member Not Found


Thank you, Scott! The db has been in use for a couple of years and I just inherited it....which tells me it has never been compiled. And I just completely overlooked the Me! portion of it.

I appreciate it very much!!!
Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#4: Oct 18 '07

re: Compile Error - Method or Data Member Not Found


Glad it's working!

Regards,
Scott
Reply