Compile error 'Method or data member not found

Question

1.00/5 (1 vote)

See more:

I am a beginner in vb6
when i run the application ,i got error message like that
Compile error 'Method or data member not found&'

My Code is here

Dim i As Integer
Dim C As Integer
Dim Rsw As DAO.Recordset
Dim rs As DAO.Recordset


gTkeyCnt = 0
gTWrdCnt = 0

On Error GoTo er

Set db = OpenDatabase("", True, False, gsConnDAO)
Set rs = db.OpenRecordSet("Select * from TestKey")
Set Rsw = db.OpenRecordSet(" Select * from NumbersToWords")
If Not rs.Eof() Then
   rs.MoveLast
   gTkeyCnt = rs.RecordCount
   rs.MoveFirst
End If

[edit]Code block added - OriginalGriff[/edit]

Posted 27-Mar-11 21:13pm

Saw Thanda Oo

Updated 27-Mar-11 21:15pm

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 28-Mar-11 3:16am

Any particular line, or should we just guess?

Sergey Alexandrovich Kryukov 28-Mar-11 3:30am

No, you did not report the error message. It should also show a name of the missing member and identify the code line number.
--SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Answer 1 · 2011-03-27T21:42:00

Solution 1

If you really want to get good help, you must be very accurate in reporting errors: you should report the exact error message that is usually pretty informative.
Hence, plese, modify the original post, including the missing bits.
:-)

Posted 27-Mar-11 21:42pm

CPallini

Abudreas · Answer 2 · 2011-03-29T00:02:00

Solution 2

The problem is simple just add this reference to your project:
Microsoft DAO 3.51 Object Liprary
to add a reference to your project click in Project menu and choose References
I hope this can help you!

Posted 29-Mar-11 0:02am

Abudreas

Comments

Muthu kumar246 2-Jan-13 8:35am

I'm Receiving the same error,When i run my application,"Compile Error:Method or datamember not found" in Windows7 OS.If i run the same program in Windows XP. It works,May i know What's The reason Behind this problem....Please Clear ASAP.