How to remove the Access pop up ' are you sure you wish to append '

[secondangel]

Im running some queries and append and access pops up askign are you sure and i hit yes always

Anyway of turing this function off or some parameters i can run

Most things are being done in VB throught the 'on clik' of a button

The user doesnt want/need to be pressing yes a few times and i dont like running a sendkeys with {enter} several times.

Any help would be appreciated

Ashley

 

[KenHigg]

If you do this with code you turn them off/on with:

docmd.setwarnings false
docmd.setwarnings true

I think there is a macro action to do this as well...

 

[ajetrumpet]

Ashley,

If you're prompting these with code that is running, turn it off using:

docmd.setwarnings

if you're doing this stuff through the interface, you can turn it off through the tools > options MENU. Or, in 07. the ribbon's options. In all but 07, there is a place in the options menu that says something like "warn for MACROS, Action Queries, etc.." It's usually a checkbox that you can uncheck

 

[secondangel]

thanks very much the docmd option is perfect