Compile error: Can't find project or library

[nekker64]

Hi, I have this complete Audit database at work that I inherited from someone who left late last year, it has been working fine up until this week. There are report form section that I can select reports by specific topics, but when I select and press that report button, instead of the report opening up, I get the this error message pop up "Compile error: Can't find project or library" and then the Visual BAsic editor opens with code info displayed for the report from I selected. THe windows appear wit the "stLinkCriteria" selected., here is what the code looks like;

Private Sub Command24_Click()
On Error GoTo Err_BtnAllOutstanding_Click
 
    Dim stDocName As String
 
    stDocName = "frmRptRecomBySection"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
 
Exit_BtnAllOutstanding_Click:
    Exit Sub
 
Err_BtnAllOutstanding_Click:
    MsgBox Err.Description
    Resume Exit_BtnAllOutstanding_Click
End Sub

It nows happens on 3 out of 6 reports which use to work.

Any help or suggestion would be nice.

Cheers
Nekker

[nico5038]

Try:

Private Sub Command24_Click()
On Error GoTo Err_BtnAllOutstanding_Click
 
    Dim stDocName As String
 
    stDocName = "frmRptRecomBySection"
    DoCmd.OpenForm stDocName
 
Exit_BtnAllOutstanding_Click:
    Exit Sub
 
Err_BtnAllOutstanding_Click:
    MsgBox Err.Description
    Resume Exit_BtnAllOutstanding_Click
End Sub
 

As there's no Dim for the stLinkCriteria and it's not filled either.
Also check or there's no Dim stLinkCriteria at the top of the code...

Nic;o)

[MSeda]

does it happen on all computers, some, or just yours?
sometimes when updates are applied to other programs (Like Outlook) the references Library gets messed up.
usually the line of code that gets highlighted when this happens has absolutely nothing to do with the error.
in the VB editor click tools then references and see if any are labeled MISSING:
uncheck these.

http://support.microsoft.com/kb/283806

[nekker64]

I would like to thank you both for your assistance with this matter but MSeda hit the nail on the head. He was spot on with his suggestion, it was exactly the problem the article stated. I removed the tick from the missing reference link and it all works again. I think it was due to a recent upgrade from Office Xp to Office 2003. Anyway, your fast responses have helped me from having to re-create a new database from scratch.

Cheers
Nekker

[MSeda]

Glad to help.