September 2nd, 2005, 10:04 AM
|
|
Contributing User
|
|
Join Date: Sep 2004
Posts: 68
Time spent in forums: 11 h 34 m 21 sec
Reputation Power: 5
|
|
|
Help needed -> Compile error: can't find project or library!
Hi
I have a problem which I can't seem to resolve, I get an error message "Compile error: can't find project or library!" The problem occurred when I installed Access run-time 2000 on one of the user's computers, I also logged myself into that computer, now it seems to have corrupted all my VBA codes and the inbuilt VBA codes like the one below I have attached a print screen of the error and highlighted the place where Access indicate the error... Can anyone help me?
Code:
Option Compare Database
Option Explicit
Sub Form_Current()
Dim ParentDocName As String
On Error Resume Next
ParentDocName = Me.Parent.Name
If Err <> 0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Me.Parent![Product Subform].Requery
End If
Form_Current_Exit:
Exit Sub
Form_Current_Err:
MsgBox Error$
Resume Form_Current_Exit
End Sub
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
