Modifier queries doen’t ask, all answers become yes.

[Manone]

 I would like to solve that my modifier queries doesn’t ask or give informations, but the answers become ‘yes’. How can I solved it? Thank you for your help!

[Bulzie]

Are you trying to surpress the notification from say an Update or Append query? If so you can use:
Docmd.SetWarnings False
Run Update Query
Docmd.SetWarnings True

[Manone]

Thank you, but it is not good for me.
for example delete queries give information about deleting and the basic answer is "no", and the Docmd.SetWarnings False take the basic answer, but I want always "yes".

[isladogs]

So you want to run the queries or SQL code with no warnings?
For SQL code use CurrentDB.Execute instead of DoCmd

[Manone]

Hi. I want to run queries from qbe grid, but docmd was found in macro commands and I tried it so it is not good. I’ll try your idea.
Thank you

[pbaldy]

If you want to run queries from the navigation pane or design view, you can turn off the warnings in File/Options/Advanced/Confirm. I personally never use that. It's Access-wide, not database specific, so other databases will be affected. It's also user specific, so you can't count on other users having that setting. I also never let users access the navigation pane or design view.

[Bulzie]

Don't understand this part:

for example delete queries give information about deleting and the basic answer is "no", and the Docmd.SetWarnings False take the basic answer, but I want always "yes".

If you run a delete query with SetWarnings to False, then it will delete them without giving you the box to select either Yes or No. Maybe explain again what you want to happen when someone runs a query?