VBA command- XP vs W2000

[Ramy27]

The following function works in one computer with XP. But it doesn’t work with windows 2000.

Public Function FormatDateForSQL(ByVal DateToBeFormatted As Date) As String

FormatDateForSQL = "#" & Format(DateToBeFormatted, "mm-dd-yyyy Hh:Nn") & "#"

End Function


It says:
“Compile error :
can’t find project or library”

and it highlights the word Format.

Does any one know why?


---------------------------------
Your help is much appreciated, R.
---------------------------------

 

[PHV]

Checks the references:
when in VBE (Alt+F11) menu Tools -> References ...
And be sure the whole project compiles fine:
menu Debug -> Compile ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Ramy27]

When I compile, I get the compile error mentioned above.

In the refernce it says That the following 2 ref are MISSING:

Microsoft OLE DB provider for OLAP Services connection dialog 8.0
Microsoft OLE DB provider for OLAP Services dialog interfaces 8.0

I followed the link, but the file isn't there in the program. So, how do i get the file. With .dll files, we can't copy and paste can we?

---------------------------------
Your help is much appreciated, R.
---------------------------------

 

[Ramy27]

The files missing are:

msolap80.dll
msolui80.dll

---------------------------------
Your help is much appreciated, R.
---------------------------------

 

[PHV]

So, how do i get the file
Apply all the Windows Update and Office Update to the w2k box.
If that not suffice, search the MS site.
At last resort, consider an OS upgrade ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244