Client Settings.

[serino]

Is there a way to disable the Client Settings "Confirm" for the queries? I have multiple users and I have to do this manually for each time a new user logs into a windows machine. It would be nice I I could do this once per machine and all three check boxes are disabled for all users.

Thanks for your assistance!

 

[Andrzejek]

You may do it in your code:

[blue]DoCmd.SetWarnings False[/blue]
[green]
' Do something here[/green]
strSQL = "DELETE * FROM customers"
DoCmd.RunSQL strSQL
[blue]
DoCmd.SetWarnings True[/blue]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[lameid]

I prefer this methodology in general to Andy's...

Turning 'SetWarnings' on and off will suppress all errors from being seen. Which is ok for static queries and you could use docmd.openquery to open a saved query too.

But if you were building your SQL statement programmatically... Then the execute method will throw an error if your query doesn't run or even if the backend is corrupt...

DIM db as DAO.Database 'requires a reference to  DAO/ Data Access Objects

set db = currentdb()

strSQL = "DELETE * FROM customers"
db.execute strSQL, dbFailOnError