Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I suppress query confirmation popups?

Status
Not open for further replies.
OhioSteve

OhioSteve

MIS
Mar 12, 2002
1,352
US
In the Access GUI you can go to tools/options/Edit-find. Then you can uncheck "action queries". This stops access from warning you before it runs an insert, update, or delete statement.

How do I do that in vba?
 
Sort by date Sort by votes
Oh! I forgot something. It would be helpful to know the current status of the checkbox.
 
Upvote 0 Downvote
Concerning question 1 take a look at the setwarning method.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
364
Moss100
Moss100
IrishJim
  • Locked
  • Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
254
IrishJim
IrishJim
btamsgn
  • Locked
  • Question
How to edit column chitoi into TableA
Replies
0
Views
163
btamsgn
btamsgn
TheresAlwaysAWay
  • Locked
  • Question
Why can't I suppress warnings after Update Query? 3
Replies
14
Views
201
xweyer
xweyer

Part and Inventory Search

Sponsor

Back
Top