469,590 Members | 2,171 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,590 developers. It's quick & easy.

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.

Sep 11 '07 #1
1 2400
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.
Sep 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

67 posts views Thread by Steven T. Hatton | last post: by
6 posts views Thread by Peter Frost | last post: by
6 posts views Thread by Thomas Connolly | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.