append query warning

[kabir_hussein]

Hi

this may be very simple but does anyone know if you can get rid of the append query warning. I know how to change it using the tools, then option.

But i was hoping there was a way where you could elimate it all togeather.

many thanks

 

[Mile-O]

DoCmd.SetWarnings False
DoCmd.OpenQuery "MyAppendQuery"
DoCmd.SetWarnings True

 

[kabir_hussein]

thank you works perfectly