Update query running notifications

[Esmatullaharifi]

I am using a lot of update queries using forum buttons but every time running the queries i must click yes - yes - yes and so on. How can I prepare these answers to update query using VBA or another way.
My main purpose is this that when running an update query the records must be update without asking me with one click.
I am looking forward for your answers.
Thanks,

 

[pr2-eugin]

Could you please show some code you are using?

 

[plog]

I am using a lot of update queries

Why? I think this is the issue you should be focusing on and not the warnings. Action queries (UPDATE, INSERT, DELETE, etc.) are a sign that you have an improperly structured database and/or don't understand how databases are to work.

Data shouldn't be moved, removed and changed wholesale. Often, what you need is a simple SELECT query (and an understanding of what it does) and not a bunch of action queries. Can you explain why you need all these action queries?

Ok, that's the spiel about doing things the right way. What you want to do, is probably turn off the confirmation prompts:


https://support.office.com/en-gb/ar...n-or-off-e58e4bba-9d54-4b9d-b962-9eca048e5335