Don't show error message

[Guest]

Hi!

I have a macro with:

CopyObject
Destination Database: C:\Week\BckWeek.mdb
NewName: =Bck() <in my Public Function Bck()>
Source Object Type: Table
Source Object Name: T_Data

OpenQuery
Query name: Q_BckWeek <AppendQuery>
View: Datasheet
Data Mode: Edit

When macro run show us next error message:
Could not find output table 'Bck'

But Bck was created trought:
Public Function Bck()
and work fine.

How is possible don't show this error message, because the procedure was
correctly executed?

Thanks in advance.
an

 

[Guest]

Hi,
this is one limitation of Macros. They cannot handle error handling (at
least not in any of the current versions...Access 2007 will allow some error
handling within macros).
Try to convert your Macro to VBA code...then include error handling to trap
the error.
HTH
Good luck