Can dialog prompts be shut off? 2

[ZPlay]

I am using the doCmd.OpenQuery to insert and delete records. Is there a way that i can get rid of all the dialog prompts that keep poping up when ever the commands are executed?

 

[jitter]

You could try:


DoCmd.SetWarnings = False
'do your stuff here
DoCmd.SetWarnings = True


I hope this helps....

 

[Guest_imported]

they can be completely switch off via the tools/options menu. just untick the confirm record changes checkbox in the Edit/Find dialog.

 

[jimmythegeek]

You can use the SetWarnings, but I recommend the follwing instead, becuase SetWarnings will eliminate any response from the database, even an error you may want to see. Where as the SetOption only affects the action queries.

==========
Application.SetOption "Confirm Action Queries", False
DoCmd.OpenQuery "YourQuery"
Application.SetOption "Confirm Action Queries", True
==========

This is the programmatic equivalent to x-s' response. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[ZPlay]

I think I like Jimmy's suggestion better but it is good to know about the "setwarnings." Thanks for the response. Dan