Compile Error

[henio]

I have inherited an application which alledgedly works. When I try to compile it I get a "Compile error - Can't find project or library" message. Two examples of lines that fail:

MsgBox "Error during import process." & Chr(13) & "Check CSV file and format match and then retry.", vbCritical, "File Error"


PlanTitle = InputBox("Please enter text for printout title", "Plan Title", "Hoddesdon Transport Plan " & Format(Now() + 1, " - dddd dd mmmm yyyy&quot)

With the first line the Chr(13) is highlighted. With the second line the Format is highlighted.

Can anyone shed some light on this?

Thanks,
Henio

 

[jrbarnett]

Henio,

I would open the database, open a code window and go to tools -> references and go down the list of ticked references and see if the word "MISSING" is against any of them. If there is, then note down what it is and untick it then post back here what it was.

John

 

[henio]

John,

there are two missing:

Microsoft ActiveX Data Objects (Multi-dimensional) 2.7 Library and ActiveEx type library

Cheers,
Henio

 

[jrbarnett]

Henio,

I can't see either of them in my list of installed objects on my box (I can find ActiveX Data Objects 2.5 (multi dimensional, but not 2.7), and can find no trace of ActiveEx.
I would try unticking them and see if this fixes the database.

John

 

[henio]

John,
I did as you suggested and it worked.

Thanks,
Henio