Compile Error - Method or Data Member Not Found

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

 Private Sub Mentioned_Employee_GotFocus()

 Mentioned_Employee.BackColor = 65535

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

Oct 18 '07 #1

Subscribe Post Reply

6657

Scott Price

1,384

Expert 1GB

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

Me![Mentioned_Employee].Backcolor

Regards,
Scott

Oct 18 '07 #2

DThreadgill

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!!!

Oct 18 '07 #3

Scott Price

1,384

Expert 1GB

Glad it's working!

Regards,
Scott

Oct 18 '07 #4

by: Andy Eshtry | last post by:

Dear Friends I have a urgent problem to solve. I have created a class and its collection and then bind it to a datagrid but got the following error. Please help. Thanks in advance. Andy Eshtry ...

.NET Framework

Compile error: Method or Data Member Not Found

by: Kenny G | last post by:

Hello, Got a small problem: I built a small table and used the following on my laptop this morning. This code compiled and worked fine on my laptop but when I compiled the first Sub on my...

Microsoft Access / VBA

Help! Compile Error: Method or data member not found

by: bradleyp | last post by:

Hi all, Hopefully somebody can help. In Access 2002-SP2, I receive an error from the VB Editor if I try to compile the following code (see below). The error is as follows: Compile Error:...

Microsoft Access / VBA

DataRelation Error. No default member found for type

by: mazda_88 | last post by:

I have a number of tables inside a dataset. I have a repeater that I need to bind to. The data that is needed resides in two tables in the dataset. Here is the code that I'm using: Dim...

ASP.NET

Error: No default member found???

by: Tim::.. | last post by:

Can some one please tell me why I'm getting this error! I presume it is because there is something wrong with my Database connection but am not really sure what! Thanks ...:: Error ::.....

ASP.NET

data member not found

by: meetmaruthi | last post by:

Hai i am searching a database (in ms access ) to validate user info.it has two fields username and password. here is the coding and i get compile error:Method or data member not found.please help...

General

Method / Data not found, IBM Mainframe GUI/macro

by: solrium | last post by:

Good morning, Thanks in advanced.... and Here are the basics: VB 6.3 on W2K, Using for WRQ Reflections for IBM (v 13.0) Visual Basic Editor (built into the above mainframe) - As most...

Visual Basic 4 / 5 / 6

compile error:Method or data member not found

by: jayjayplane | last post by:

I have two combo boxes on my form, let's say box1(s1_individual_session) and box2(s1_nationality1), initially I disable box2(gray-out). I want to select box1 value is "true" then enable the box2, ...

Microsoft Access / VBA

Compile error: Method or data member not found?

by: Elizabeth Mitte | last post by:

Hello, Before I ask my question, I want to say how good this forum is and how much help it has been to a complete novice. At this moment in time I am having trouble creating VBA syntax (I think...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Compile Error - Method or Data Member Not Found

Similar topics