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

Problems created by Recent updates to Outlook 365 0
Synchronization problems while moving folders to new email 1
Is It Possible to Control Access Warning Pop-Up Message Boxes? 6
WORD VBA Search and switch to advanced ... 1
Update Query Running From Form 2
Using the Where clause in an update query 0
Update/Append Queries minus confirmation Dialouge 3
Access update query 2

Top