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?

The code:
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

It sounds like your IT people have been updating your company's machines and (deliberatly or not) either moved or deleted one of the dll/ocx files your database is dependent on.

My recommendation? Mount a 24/7/365 guard on the remaining machine and deal violently with any IT guys who stray within the exclusion zone...:D


Brian Skelton
Braxis Computer Services Ltd.

Interesting - we are a small company and don't really have an IT department. I wonder how things would get moved or deleted. It seems odd that character codes and date functions would go bad...

I think I'll try re-installing MS Office on one of the suspect machines and see if that helps - does that sound resonable?

It's not Office. It looks to me as if your installation of Windows has been corrupted. The previous correspondent was correct in thinking along the lines of dll files. This happens regularly on busy machines, why? I do not know. It looks to me as if your International Settings and ASCII converters have gone awry. Try Windows, not Office

Alan T

Ken

If any of your library references are missing or corrupted the simple, 'inbuilt', VBA functions tend to stop working. It's usually shows itself with the left/right/mid functions in my databases.

If you open the database on one of the broken machines and look at the references do any of them show as missing?


Brian Skelton
Braxis Computer Services Ltd.

That was it - I finally had a chance to get back to this - I had checked a reference for a completely different function in a completely different database. It was "missing" on the other computers. I unchecked, problem went away.

Thanks!!:)