J JP Sep 15, 2003 #1 When I run an update query I want to make it so none of the messages about updating pop up... Any way to do that?
When I run an update query I want to make it so none of the messages about updating pop up... Any way to do that?
G Greg Green Sep 15, 2003 #2 If you are doing this from a form, before the event you can set the global: DoCmd.SetWarning False This suppresses certain system messages and may work in your situation. Greg
If you are doing this from a form, before the event you can set the global: DoCmd.SetWarning False This suppresses certain system messages and may work in your situation. Greg
D Denbo Sep 17, 2003 #3 BEWARE!!! If you use DoCmd.SetWarnings False to disable messages you MUST counteract the command with DoCmd.SetWarnings True If you don't, ALL confirmation messages in all apllications (including Delete and Save) will be disabled until you close and re-start Access. This means you can do untold damge to your data without realising it, or being given the option of not executing a command. Use SetWarnings carefully. Denis
BEWARE!!! If you use DoCmd.SetWarnings False to disable messages you MUST counteract the command with DoCmd.SetWarnings True If you don't, ALL confirmation messages in all apllications (including Delete and Save) will be disabled until you close and re-start Access. This means you can do untold damge to your data without realising it, or being given the option of not executing a command. Use SetWarnings carefully. Denis
