VBA, Problem with On Error Resume Next in a converted database

Problem with On Error Resume Next in a converted database

Author	Message
Carl Imthur #1 / 6	Problem with On Error Resume Next in a converted database I recently converted an Access 97 .mdb file to Access 2000. The conversion went fine -- no errors were reported, and it opens in Access 2000 with no problem. I run the following code snippet: On Error Resume Next DoCmd.DeleteObject acTable, "tbl_FINAL01" DoCmd.DeleteObject acTable, "tbl_FINAL02" and I receive a message box with the following: Run-time error '7874': Microsoft Access can't find the object 'tbl_FINAL01.' Which is absolutely true (it does not exist), but it appears that the On Error Resume Next is not functioning This code has been working without a hitch in Access 97. What am I missing . . . ? Is there a conversion issue that I'm not aware of?
Fri, 20 Aug 2004 09:03:20 GMT

Peter L Reade #2 / 6	Problem with On Error Resume Next in a converted database Quote: > I recently converted an Access 97 .mdb file to Access 2000. > The conversion went fine -- no errors were reported, and it opens in > Access 2000 with no problem. > I run the following code snippet: > On Error Resume Next > DoCmd.DeleteObject acTable, "tbl_FINAL01" > DoCmd.DeleteObject acTable, "tbl_FINAL02" > and I receive a message box with the following: > Run-time error '7874': > Microsoft Access can't find the object 'tbl_FINAL01.' > Which is absolutely true (it does not exist), but it appears that the On > Error Resume Next is not functioning > This code has been working without a hitch in Access 97. > What am I missing . . . ? > Is there a conversion issue that I'm not aware of? Check the Options in the Tools menu item in the VB window. It might be that the option (under General) "Break on all errors" is checked. If so, change to "Break in class module".
Fri, 20 Aug 2004 10:00:05 GMT

Brian Camir #3 / 6	Problem with On Error Resume Next in a converted database In the Microsoft Visual Basic window (which you can display by selecting Tools, Macro, Visual Basic Editor), select Tools, Options. In the Options dialog that appears, click the General tab. Check the Error Trapping setting. If it's "Break on All Errors", your execution will stop on all errors even if you have an error handler. Try "Break on Unhandled Errors". Check the help for details. Quote: > I recently converted an Access 97 .mdb file to Access 2000. > The conversion went fine -- no errors were reported, and it opens in > Access 2000 with no problem. > I run the following code snippet: > On Error Resume Next > DoCmd.DeleteObject acTable, "tbl_FINAL01" > DoCmd.DeleteObject acTable, "tbl_FINAL02" > and I receive a message box with the following: > Run-time error '7874': > Microsoft Access can't find the object 'tbl_FINAL01.' > Which is absolutely true (it does not exist), but it appears that the On > Error Resume Next is not functioning > This code has been working without a hitch in Access 97. > What am I missing . . . ? > Is there a conversion issue that I'm not aware of?
Fri, 20 Aug 2004 09:59:18 GMT

Graham R Seac #4 / 6	Problem with On Error Resume Next in a converted database Carl, 1. In a code module, select the Tools menu --> Options. The Options dialog box is displayed. 2. Select the General tab. 3. Under [Error Trapping], ensure that the [Break on Unhandled Errors] option is selected. 4. Click OK. - Graham R Seach MVP Quote: > I recently converted an Access 97 .mdb file to Access 2000. > The conversion went fine -- no errors were reported, and it opens in > Access 2000 with no problem. > I run the following code snippet: > On Error Resume Next > DoCmd.DeleteObject acTable, "tbl_FINAL01" > DoCmd.DeleteObject acTable, "tbl_FINAL02" > and I receive a message box with the following: > Run-time error '7874': > Microsoft Access can't find the object 'tbl_FINAL01.' > Which is absolutely true (it does not exist), but it appears that the On > Error Resume Next is not functioning > This code has been working without a hitch in Access 97. > What am I missing . . . ? > Is there a conversion issue that I'm not aware of?
Fri, 20 Aug 2004 10:02:46 GMT

Carl Imthur #5 / 6	Problem with On Error Resume Next in a converted database Thank you all for being so nice about pointing out something I should have been able to catch myself. And for responding so quickly. I wish they were all this easy . . . Thanks again -- all of you. Carl
Fri, 20 Aug 2004 10:26:33 GMT

Page 1 of 1

[ 6 post ]