How to eliminate the system check-boxes?

[shkrebs]

Hi.

When you are running a Append- or Delete query, Access ask you "You want to append 8 row(s) bla. bla. bla. Do you want to proceed? YES / NO"

I'm running my queries from VBA and to make life a little easier for the end-users I want to get rid of those check-boxes, but I really don't know where to look for an answer.

Any ideas??????

Best regards
Soren

 

[joeyreyma]

try:

DoCmd.SetWarnings FALSE
you append/delete query goes here
DoCmd.SetWarnings TRUE

 

[shkrebs]

Hi joeyreyma

Thanks - so it's called SetWarnings - guess I should have told myself that loooong time ago

Regards
Soren