Compile Error 1

[Tronsliver]

This has me confused. This program worked fine now I'm getting a compile error. I assume it has something to do with a unregisted library. However, my skills are basic. When I try to compile I get:

Compile error:
Can't find project or library

Also the apersand is highlighted in the code after Forms!RaterF!LName in the third line of code after "Set rst = ..."

Sure would appreciate some expert help...thanks

Private Sub Form_Delete(Cancel As Integer)
Dim rst As Recordset
Dim x, varx As Byte

Set rst = CurrentDb().OpenRecordset("Rater", dbOpenTable)

x = Findx(varx)

If x > 0 Then
MsgBox (Forms!RaterF!LName & " is in " & x & " rating scheme(s)." _
& Chr(13) & "Must replace " & Forms!RaterF!LName & " in all" & Chr(13) & _
"schemes before you can delete &quot
Forms!RaterF!SSN.SetFocus
End


End If
End Sub

 

[jrbarnett]

Which version of Access are you using?

John

 

[Tronsliver]

Access 97

 

[danvlas]

Open a module, Tools-References and see what is MISSING:

You may have deleted or uninstalled a referenced program.
Remove the reference or reinstall the program

Good luck




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Tronsliver]

OK I opened the form module and went to tools, references and opened. It has many references with check marks and many without. How do I tell which one needs to be loaded?

Thanks

 

[danvlas]

The one or more that are checked and start with "MISSING:"

...





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Tronsliver]

This is weird the one that is missing is "Microsoft Jet SQL help topics" this shouldn't have anything to do with compiling the module should it?

 

[danvlas]

Just uncheck it...



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Tronsliver]

Damn that worked...why would a help file cause this?