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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update query

Status
Not open for further replies.
jeff1

jeff1

IS-IT--Management
Nov 8, 2000
49
US
Can I run an update query upon update on a form that runs in the background. I have the query running but importantly I do not want the query to ask if it is OK to Modify data. The user does not need to know that the query is running.

Thank you in advance for your help.
 
Sort by date Sort by votes
This code will keep the warning boxes from flashing up.

DoCmd.SetWarnings False
:
: your code that you don't want warnings for :
:
DoCmd.SetWarnings True
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
784
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
715
dhookom
dhookom
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
601
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
582
TrekBiker
TrekBiker
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
335
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top