Stop macro on error

[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

 

[Jeff Boyce]

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

 

[Marco]

Hello.

I'm with Access 2003.

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

Thanks,
Marco