hide a message

[Avi Algazi-Atik Computers Ltd]

Hi to all

I run from a form some queries and the popup a messages that the query hi
update who i can trun it off
without no message at all
thanks avi

 

[Wayne Morgan]

At depends on what syntax you use to run the query. If you use DoCmd.RunSQL
you can try

DoCmd.SetWarnings False

before you run the query and set it to True again when you're done.

Another option is to use different syntax.

Example:
CurrentDb.Execute "QueryName", dbFailOnError
or
CurrentDb.Execute strSQL, dbFailOnError

 

[_Bigred]

You can create a macro

setWarnings .. No
OpenQuery .. select your query

Then set the form to run the queries "on the open event" by setting the
macro to run on open. You can then put all your queries in 1 macro and have
them run when the form opens.

hope this helps,
_Bigred

 

[Avi Algazi-Atik Computers Ltd]

thanks