on error does not work suddenly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have years of VBA programming experience with Access and I used to insert
statements like "on error goto labelx", or "on error resume next", etc.

this is a very simple piece of code:
Sub TestA()
On Error Resume Next
Kill "E:\aaa.rpt"
End Sub

In my machine, running the above codes always finished quietly, no matter if
the file aaa.rpt exist or not. But when I run it after starting Access in a
Citrix Metaframe environment the code ALWAYS breaks if the file "E:\aaa.rpt"
does not exist. I don't want the code to break. I am really stuck.

The only possible solution I could think of is to re-install Office.

Do I miss anything? I don't really want to re-install Office.
 
Before you re-install anything, make sure you don't have the option selected
to break on all errors.
 
Back
Top