
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?