I have an Access 2000 database that has been operating for about 2 years without an issue. The whole mdb file is on the server (no front end / back end) and is used on perhaps 5 machines throughout the company.
All of a sudden, when a report is called with "no data", a custom message should appear. This works on one machine (mine), but now causes an error on all other machines, with a "Chr(13)" (return) highlighted. When I take out the "Chr(13)" the code executes on all machines. Why would one machine be different?
Private Sub Report_NoData(Cancel As Integer)
MsgBox "The report has no data." & Chr(13) & "Check your Dates and operator information." _
& Chr(13) & "If operators have not been updated this report will not print!", _
vbInformation, "No Report Data"
Cancel = True
End of the code.
I had a similar incident with code inserting a date on a form, and ended up commenting out the code for the time being.
Why would this happen after 2 years of operation? Why would one machine work, and not others? What causes a library or project to be missing? I can work around this, but really want to understand what is happening. Any help is appreciated - Ken