Button on Message Box

[Guest]

I have used some VBA code on one of my forms to to automatically append data
to another table when a certain value is entered. Now whenever i add data
that will be appended i get a message box that asks me to confirm the append.
Without completely disabling warning boxes, is there any way to have it so
that "yes" is automatically selected when this message box pops up (i know
that "Yes" is the default , as that is highlighted box). Thank you for any
help you can provide.

 

[kingston via AccessMonster.com]

Try this to bypass the message:

DoCmd.SetWarnings False
Append
DoCmd.SetWarnings True

 

[Alex Dybenko]

Hi,
you can use docmd.setwarnings to control this:

docmd.setwarnings false
docmd.runsql "Insert into ..."
docmd.setwarnings true


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

THank you very much

Try this to bypass the message:

DoCmd.SetWarnings False
Append
DoCmd.SetWarnings True