Disable Yes/No Box (1 Viewer)

[danielgraham]

Hi

I have a query that pastes fields into another table. how can i get if to stop asking me and just do it


thankyou

 

[GrahamB]

SetWarnings option in Macros or VBA

Note: Make sure you turn the warnings back on after you have run the query.

So in a Macro

SetWarnings (No)
OpenQuery
SetWarnings (Yes)

Or in VBA

DoCmd.SetWarnings False
DoCmd.OpenQuery "Query Name"
DoCmd.SetWarnings True