Stop macro on error

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

Hi.

How can I stop a macro if the macro it self returns a error?

I have a macro that deletes a table but some several reasons sometimes that
table that is supposed to be delete don't exist. When this happens it returns
me an error.

How can I prevent this?

There's any way to only run a macro if the table exists or stop if the macro
returns in error?


Regards,
Marco
 
Marco

If I recall correctly, macros don't have error handling.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hello.

I'm with Access 2003.

I solved by creatying a dummy table just to delete it in the next step.

Thanks,
Marco
 
Back
Top