Warnings

[border20]

I built a databse with access 2000. In the database are alot of Updatequery operations... but when I run the DB in access Xp. I get a Warning saying that i am about to modify X records... that get anoying... is there a way to stop there warnings ?

 

[neileg]

Two ways

Use the SetWarnings command to turn warnings off and then on again in your code.

Go to Tools\Options\Edit/Find Uncheck the box for Confirm Action Queires.

 

[Pat Hartman]

It is far better to use the SetWarnings in code so you can turn the warnings back on immediately after running the query. Using the menu options is dangerous because if you forget, you may lose object updates. For example, if you leave the warnings off - if you change a form and then click the x to close, Access will close the form without saving and without warning you that is discarding your changes.