By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.