ERROR Message on Form Open - Compile error: can't find project or library

[Bob]

Hi all,

I've created a database at work and have copied it to home but have
had some problems when I try to open the main form. The error when I
run it is:

Compile error: Can't find project or library

This error comes up then it highlights the 'date' function in the
following line of code:

intTodayPos = Int(Format(Date, "dd")) + Int((7 -
Format(fCalendarDay(Format(Date, "mm"), Format(Date, "yyyy"), 7, 1),
"dd")))
It also highlights the 'left' function in the following code:

strOutput = Left(strOutput, Len(strOutput) - 1)
Does anyone know what the problem is?
I really don't know where to start.. I would have thought those
functions are just built into access .. or do they hinge on setting
correct references... ??

Any help would be much appreciated as I need to work on the database
at home.

Kind regards,

Bob.

[Tom van Stiphout]

On Mon, 10 Sep 2007 19:31:47 -0700, Bob
<sc*******@colonialfirststate.com.auwrote:

This is the most-asked question in this newsgroup, so you should have
no problem finding posts about "Missing References".

-Tom.

>Hi all,

I've created a database at work and have copied it to home but have
had some problems when I try to open the main form. The error when I
run it is:

Compile error: Can't find project or library

This error comes up then it highlights the 'date' function in the
following line of code:

intTodayPos = Int(Format(Date, "dd")) + Int((7 -
Format(fCalendarDay(Format(Date, "mm"), Format(Date, "yyyy"), 7, 1),
"dd")))
It also highlights the 'left' function in the following code:

strOutput = Left(strOutput, Len(strOutput) - 1)
Does anyone know what the problem is?
I really don't know where to start.. I would have thought those
functions are just built into access .. or do they hinge on setting
correct references... ??

Any help would be much appreciated as I need to work on the database
at home.

Kind regards,

Bob.