hide a message

  • Thread starter Thread starter Avi Algazi-Atik Computers Ltd
  • Start date Start date
A

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