Can you supress display alerts via VBA ?

[Linus_99]

Hi,

I'm developing an application in Access where I have to create a temporary table on the fly. During the process, Access prompts with alerts saying that the previous table will be deleted, a number of rows will be pasted etc. The user has to click OK a couple of times to get past these messages (and the messages in themselves are frightening to normal mortals . . . )

Is there any way to suppress these messages ?

In Excel, you can turn off annoying display alerts by:

Application.Displayalerts = False

Any advice would be appreciated.

 

[bmacr]

Try
DoCmd.SetWarnings False

Remember to set it to true again as this will suppress warnings that might be useful.

 

[Linus_99]

Thanks,

That's exactly what I was after.