How to determine which reference to activate

[giedrius]

I use functions Replace and InStrRev, which are standard in A2K, extensively in my modules, however I had to "hard code" them explicitly as they are not accessible with the following references enabled:

VB for Applications
MS Access 9.0 Object Library
OLE Automation
MS ActiveX Data Objects 2.1 Library
MS DAO 3.6 Object Library

Do you know which additional reference has to be enabled in order to have functions Replace and InStrRev work without having to code them myself?

giedrius

 

[WayneRyan]

g,

I'm going out on a limb here. I don't think that your problem
resides there. If you are in a multi-user situation, I think that
"users" switching between various versions of Excel, Word,
and Ms Project is what is getting you.

Do you find that the various versions of these apps become
"unchecked" when you get your code in design view and
check Tools --> References?

Wayne

 

[giedrius]

Wayne,

I actually did not reach the stage of deployment of my application yet, therefore all this is happening on a single machine. The references listed are always checked.

After your hints I, though, recall that at some stage I tried to rename my own functions so that standard ones are forced to be called and it worked somehow. But then the next day I had to enable my own code again in order to have Replace and InStrRev work.

Does this give you any hints where the problem rests?

giedrius