Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / October 2005

Tip: Looking for answers? Try searching our database.

on error does not work suddenly

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ykffc - 29 Oct 2005 10:22 GMT
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.
Duane Hookom - 30 Oct 2005 06:02 GMT
Before you re-install anything, make sure you don't have the option selected
to break on all errors.

Signature

Duane Hookom
MS Access MVP

>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.
[quoted text clipped - 16 lines]
>
> Do I miss anything?  I don't really want to re-install Office.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.