Run Update Query with out Message boxes and OK 1

[storyboy]

I would like to run an update query in the background and not have it show the message box or ask for ok to continue as that is part of its usual routine, can I turn it off. Can you please tell me where that is done if I can do it.
Thank you so much. I have read many screens, pages of them, to see if anyone else has asked this and didn't find any to help me with this so I bring the question to you. What a fantastic site, so many questions, so many wonderful people.

Your assistance is appreciated and I thank you for your taking your time to survey this question and any help you can give.
Tom

 

[Remou]

Hi
If you are running queries:
On the Tools menu, click Options.
Click the Edit/Find tab.
Under Confirm, select or clear the appropriate check boxes.
If you are using VB:
DoCmd.SetWarnings = False
DoCmd.SetWarnings = True
Please note that this is very unsafe - see Microsoft Access help on SetWarnings

 

[storyboy]

This was just what I needed. I'll use the vb code thing because I can just set it to false for the time that it is needed then back again. Thanks for your help. Not sure about the unsafe part as it is just a simple update that shouldn't harm any of the data, only sets up the table for a simple report. I appreciate the time you took to answer my question, I really needed the help with this. I hope in time I will be able to help others, lots of learning to do but with the way I enjoy Access it's only a matter of time.
Thank again.

 

[Remou]

Hi
You are welcome. I mentioned 'unsafe' because the Help file devotes a whole paragraph to it! If you are happy with what you are doing, you do not need to see all those warnings.