auto answer on system message

[Guest]

when I create table using VB there is system 'yes no' message asking to
create a table or not.

how can I switch it off or automatically answer yes not to let users to
interupt?

thanks

 

[John Vinson]

when I create table using VB there is system 'yes no' message asking to
create a table or not.

how can I switch it off or automatically answer yes not to let users to
interupt?

thanks

In your code (VB? or VBA?) put a line

DoCmd.SetWarnings True

before the table creation event; and

DoCmd.SetWarnings False

afterward. Or, use the querydef's Execute method.

John W. Vinson[MVP]