STOP Delete existing table confirmation

G

Guest

Is there any way to stop the confirmation message that asks if you really
want to delete the existing table when re-running a make table query? When I
have 30 queries in a macro and you have to make 30 confirmations to delete
the tables before they are re-generated, somewhat annoying.

Am able to stop all of the other confirmation messages appearing from
Tools>Options?Edit/Find. Am Running Access 2003.

Thanks
 
F

Frederick Wilson

Andy said:
Is there any way to stop the confirmation message that asks if you really
want to delete the existing table when re-running a make table query? When I
have 30 queries in a macro and you have to make 30 confirmations to delete
the tables before they are re-generated, somewhat annoying.

Am able to stop all of the other confirmation messages appearing from
Tools>Options?Edit/Find. Am Running Access 2003.

Thanks
I am not sure if marcos are the same as form coding but for the latter
here is what you do.

DoCmd.Setwarning False
Do you stuff here
DoCmd.Setwarning true

IMPORTANT NOTE. If you fail to turn the warnings back on, all other
warnings will be suppressed. With this said I recommend error trapping
such as

on error goto Err_trap

your code

DoCmd.Setwarning False
Do you stuff here
DoCmd.Setwarning true

Err_trap_exit:
DoCmd.SetWarning True

Err_trap:
Some code here
resume Err_trap_exit
 
V

Van T. Dinh

Use SetWarnings Macro action (No for Warnings On argument) at the beginning
of your Macro and (may not be necessary) use the same with Yes for Warnings
On argument at the end of your Macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top