Automatic Yes

[YellowTail]

I have a developed SQL statement that develops tables. Each time a table is created I get Yes/No question if I want that to be created.

I use this statement to run my SQL statment.
DoCmd.RunSQL srsl

I would like to have a default answer to be 'Yes', what is the process for doing this.

 

[danvlas]

DoCmd.SetWarnings False ?

Alternatively, you could use CurrentDb.Execute YourSql
or
CurrentProject.Connection.Execute YourSql

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Zion7]

Don't forget to turn on again...

DoCmd.SetWarnings False
DoCmd.RunSQL srsl
DoCmd.SetWarnings True

or, to execute no records...

Currentproject.Connection.Execute _
"CREATE TABLE tblCountry" & _
" pkCountryID PRIMARY KEY AUTONUMBER..." & _
" ...txtCountry TEXT(50)",,adExecuteNoRecords

no recordset will be returned (less taxing) (ADO or DAO)

 

[TheAceMan1]

. . . or permanently turn off this response to [blue]action queries[/blue] with:
[ol][li]MenuBar - Tools - Options - Edit/Find Tab.[/li]
[li]In the [blue]Confirm[/blue] section remove the checkmark fom [blue]Action queries[/blue][/li][/ol]

See Ya! . . . . . .