UPDATE QUERY

S

steve goodrich

When running an update query from a command button on my form, I get 2
warning dialogue boxes - the first tells me that I am running the query and
the second that x amount of rows will be updated, or some thing on those
lines.
Is it possible to run the update query without displaying the 2 dialogue
boxes, or perhaps using a macro to display a message of my choice?
many thanks
Steve Goodrich
 
F

fredg

When running an update query from a command button on my form, I get 2
warning dialogue boxes - the first tells me that I am running the query and
the second that x amount of rows will be updated, or some thing on those
lines.
Is it possible to run the update query without displaying the 2 dialogue
boxes, or perhaps using a macro to display a message of my choice?
many thanks
Steve Goodrich
Click to expand...

Add 2 lines of code the the click event:

DoCmd.SetWarnings False
DoCmd.OpenQuery "YourUpdateQueryName"
DoCmd.SetWarnings True
 

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

Similar Threads

auto update query help 1
Complicated Form-Query-Form Problem 1
Append Query Issue 0
Update Query problem 7
Update/Append Queries minus confirmation Dialouge 3
Update Query Running From Form 2
How to get *just* update query confirmation 2
Combo Box changing data in Table ? 2

Top