I am trying to convert an Access 97 database to Access 2007. I get the error
message: "Compiler Error Can't find object or library" on the following code.

Err_AddBook_Click:
MsgBox Error$
Resume Exit_AddBook_Click

when the compiler encounters Error$.

Any help would be appreciated.

"Michael Trombetta" <Michael (E-Mail Removed)> wrote in
message news:6120F815-8343-4E85-8E65-(E-Mail Removed)...
>I am trying to convert an Access 97 database to Access 2007. I get the
>error
> message: "Compiler Error Can't find object or library" on the following
> code.
>
> Err_AddBook_Click:
> MsgBox Error$
> Resume Exit_AddBook_Click
>
> when the compiler encounters Error$.
>
> Any help would be appreciated.


In the VB editor, click Tools -> References..., and look for any marked
MISSING. If there are any, un-check them and, if there's an Access 12 or
Office 12 equivalent, check that one instead. If you un-checked some
references, try recompiling and see if any compile errors are raised. If
not, try running the code again and see if the problem has gone away.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Linq Adams via AccessMonster.com" <u28780@uwe> wrote in message
news:89e8afe5421c7@uwe...
> If no references show up as missing, the problem may be with the dollar
> sign
> at he end of Error$. This is a hold over from the early Basic days, and
> while
> in versions up thru v2003 they'll work, I've been seeing reports for a
> while
> of the code failing in v2007.

FWIW, I tested the code in Access 2007, with the dollar sign, and it worked
fine. So while that *may* be it, there must be some other contributing
factor. I'm still inclined to think it's a broken reference.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)