Error 94

[LEE hepworth]

Install the database on anetwork but one user gets an Error 94 she seems to be only user getting it


How can I cure this?

 

[Mile-O]

Error 94 is Invalid Use of Null.

So, at what point do you get the error message?
Are you using VBA or macros?
More details? The specifics, even.

 

[LEE hepworth]

ACCESS 97

Error 94 is Invalid Use of Null.

So, at what point do you get the error message?
Are you using VBA or macros?
More details? The specifics, even.

USING vba CODE

Resume Exit_Report_NoData
cmdOpenReport_ClickErr:
Select Case Err.Number
Case 2501 ' Cancelled by user, or by NoData event.
MsgBox "Report cancelled, or no matching data.", vbInformation, "Information"
Case Else
MsgBox "Error " & Err & ": " & Error$, vbInformation, "cmdreports_Click()"
End Select
Resume Next

 

[Mile-O]

That's just a bit of error handling. Take it off (comment it out) and find out what line is causing the error.

 

[Pat Hartman]

Open the VBA window - Tools/Options/General - check the "break on all errors" option. Don't forget to set it back when you're done testing.