Member or data member not found

[Trudye]

I am getting a msg when I attempt to compile Access 2000. Originally the database would not save (ie save failed). I decided to move all the components to a new database and see if the problem persist. After the move I clicked save and everything was ok.

Then I decided to compile my modules. On the first compile I received msg: “Method or data member not found”. The highlighted code was a ".FindFirst" command. I went into references and added MS ADO 2.1.

On the second compile I received msg:Member or data member not found. The highlighted code was "Me!Sc_id".

This code has been working for almost a year. Not to drag this out but my MS Access has been doing quirky things all week. For instance: one night help (f1) stopped working, the next night the link table wizard could not be found and I was unable to reload it. And now this! I'm thinking of having the darn system EXORCISED!

Does anyone have any ideas?

Thanks
Trudye

OBTW, I am not using classes

 

[Trudye]

Again I had to call MS. I exhausted their Knowledge Base and could find no adequate answers. They want to charge me $245.00 for the bug in their system and the inadequate presentation in their Knowledge Base. But I’ll fight that battle later, let me pass on to you what they imparted to me. So you won’t have to pay for a MS bug.

Open any module, on the Menu Bar click View;Object Browser. In the window below the window that contains <All Libraries> type the command you are having a problem with (i.e. Findfirst) and hit enter.

The library that contains your command/member will display. In my case the library was DAO, now here is the rub. I had DAO listed in my selected reference libraries, but it was positioned to low. Here is how you address that problem:
Remain in the module and on the Menu bar Click Tools;References. When the dialog box appears to the right of the listed libraries you will see Priority arrows. Move the necessary library to the top. In my case I just had to move the DAO library ahead of the ADO libraries.

The bottom line here is that the Findfirst member is in the DAO library but once the system hits the ADO library and does not find the member it issues the msg: method or data member not found.

I hope this will help programmers that encounter this problem in the future.

Trudye

 

[tim63]

For your interest, this is also the case if you have the Microsoft ActiveX Data Objects 2.1 Library referenced ahead of the DAO Library.

Tim