How to make an Update qry that does not prompt

U

UnderSeven

Is it possible and if so how would I make an update qry not prompt if the
user wants to update the records before doing it. Basically I want the query
when run to just update the records.
 
O

Ofer Cohen

When running action query using code, you can set the warning to False

DoCmd.SetWarnings False
' run your query
DoCmd.SetWarnings True
=============================
Or
CurrentDb.Execute "QueryName" , dbFailOnError

=============================
If you want to set the warnings off when you delete or append directly to
the query or using code, then in the menu bar select

Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)

But you have to remember that it will never prompt with the message event
when
you are using the queries directly
==============================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top