auto answer on system message

V

VB

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
 
J

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
Click to expand...

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]
 
Top