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

nandhabiwat · Feb 17, 2004

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 · Feb 17, 2004

I think it may be

Code:

DoCmd.SetWarnings False

that you are looking for.

Stephen

dcx693 · Feb 17, 2004

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 · Feb 17, 2004

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

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

dcx693 · Feb 17, 2004

Mile-O-Phile said:
I don't know but I'm manually fond too.

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

Mile-O · Feb 17, 2004

dcx693 said:
Are you saying that you like being "hands-on"?

Either way is fine with me.

dcx693 · Feb 17, 2004

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

nandhabiwat · Feb 18, 2004

Thanks a lot folks

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

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

nandhabiwat

New member

stephen81

Registered User.

dcx693

Registered User.

Mile-O

Back once again...

dcx693

Registered User.

Mile-O

Back once again...

dcx693

Registered User.

nandhabiwat

New member

Similar threads

Users who are viewing this thread