Message box question

[Stang02GT]

Hello,


I am just wondering if there is a way to get rid of the message boxes. For example if i run a make table query every time I run it it pops up about 4 messages....

Your about to paste XXXX rows.....
You are about to delete XXXX rows....
You have just pasted XXXX rows.....


I'm wondering if there is a way to....i dunno turn these off or have code to bypass or hide them.

[FishVal]

Hello,


I am just wondering if there is a way to get rid of the message boxes. For example if i run a make table query every time I run it it pops up about 4 messages....

Your about to paste XXXX rows.....
You are about to delete XXXX rows....
You have just pasted XXXX rows.....


I'm wondering if there is a way to....i dunno turn these off or have code to bypass or hide them.

Hi, Stang.
You should take a look at DoCmd.SetWarnings method in Access help.

[Stang02GT]

Alright thank you very much!

[missinglinq]

Just remember to turn warnings back on after running your append or whatever! Otherwise you might miss some really important message!

Linq ;0)>

[Stang02GT]

Just remember to turn warnings back on after running your append or whatever! Otherwise you might miss some really important message!

Linq ;0)>

Thank you for the reminder, because if i turned them off i probably would have forgotten to turn them off :-}