Right Functions produces an error?

[jake007]

Using the "Right" function as follows:

for each tdf in db.tabledefs
if right(tdf.name, 2) = "df" then
lstSearch.additem tdf.name
endif
next

On my Wondows 2000 system, no problem

Installed exact Same version of VB6 with SP5 on Win XP system. Copy project directory to XP station.

On compile, I get the following:

Compile Error:
Can't Find Project or Library.

The Right command from the above code is highlighted. Both project have the exeact same references checked. And ideas as to what is causing the problem?

Thanks, Jake

 

[jake007]

One other Item

One the compile fails, the word 'Right" is higlited in Blu, but once it goes into debug, the function it is in is highlited in yellow, could it be the actual funtion that is the problem.


The function is:

Private Sub SSTab1_Click(Previous Tab as Integer)

Does the SSTab require something I may not have on my XP machine?

Thanks again.

Jake

 

[DrJavaJoe]

My guess is that if open the Project references and look for MISSING on one of the entries, you'll find it, fix this and your problem should be fixed.

 

[JohnYingling]

Check for Visual Basic for Applications..., Visual Basic runtime..., Visvual Basic objects...

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[jake007]

Thanks for the help, turned out my Excel Library reference was missing. Odd that it would cause a problem with that particular function, but after re-installing excel, the problem has gone away.

thanks for your help.

Jake