How to get rid of pop-up dialog box after insertion/deletion

[nandhabiwat]

Hello everyone,

I got a couple of INSERT and DELETE qry that are called through forms and whenever those qry are activated there would be confirmation dialog boxes popped up asking whether the user wanting to proceed with insertion or deletion of such and such number of rows. I know that "DoCmd.Echo = false" won't work with these kinds of popped up message. So are there any way in ACCESS to disable the settings.
Please help. Thank you very much in advance.


IMS

 

[stephen81]

I think it may be

DoCmd.SetWarnings False

that you are looking for.


Stephen

 

[dcx693]

Why is everyone so fond of manually suppressing the warning messages? Just wondering if there is some advantage to doing that versus using the .Execute method, which automatically suppresses them: supress warning messages

 

[Mile-O]

Why is everyone so fond of manually suppressing the warning messages?

I don't know but I'm manually fond too.

 

[dcx693]

I don't know but I'm manually fond too.

Are you saying that you like being "hands-on"?

 

[Mile-O]

Are you saying that you like being "hands-on"?

Either way is fine with me.

 

[Pat Hartman]

Don't forget to set the warnings back on immediatly after your queries run. This is especially important if you are still developing in the db. If the warnings are off and you close an object that you changed without saving it, you WILL NOT BE PROMPTED! Access will simply discard the changes.

To help me avoid this problem, I always turn the cursor to an hourglass when I set the warnings off and then return the cursor to its normal state when I turn warnings back on. That way I have a visual clue to remind me that the warnings are off.

 

[dcx693]

Pat, do you know of any disadvantage in this case to using the .Execute method?

 

[Pat Hartman]

No, I use it myself.

 

[nandhabiwat]

Thanks a lot folks

Your suggestions are so valuable. Thank you very much. It works!!