message with an append query

[rainbows]

When i run the append query i get a message telling me i am about to run the query and then another one telling me how many lines will append
is it possible to stop them messages for that query

thanks
steve

 

[CJ_London]

depends how you are executing the append query. If manually or using docmd.runsql then no, if using currentdb.execute then yes

 

[arnelgp]

you can also set the Warnings to False

Docmd.SetWarnings False
DoCmd.RunSQL "sql here"
Docmd.SetWarnings True

 

[ebs17]

Turning off all notifications is not a good idea, because then error messages will also be suppressed. One should not think that one is always error-free and use only error-free data in ideal conditions.

CurrentDb.Execute "NameOfQuery", dbFailOnError
CurrentDb.Execute "INSERT INTO ...", dbFailOnError

Errors are displayed with this, and a rollback is initiated if an error occurs. So you get the defined output board before executing the query.

 

[LarryE]

Go into the ACCESS options screen and uncheck the messaging box for Action Queries. File>>Options>>Client Settings>>Confirm>>Action Queries

 

[Minty]

@LarryE - I would seriously caution against that, you might inadvertently click on an action query by mistake whilst developing and update or delete some records and not have a clue you've done it. Not a good idea.

Use CurrentDb.Execute.

 

[ebs17]

Anyone who generally ignores messages also climbs into an elevator shaft without an elevator. It would be interesting to learn how it is then possible to ignore the consequences.

 

[arnelgp]

is it possible to stop them messages for that query