disable access msgbox while runing append /delete queries

  • Thread starter Thread starter pando
  • Start date Start date
P

pando

Guest
Hello all,

I need your help for this urgent problem I have.

I need that each time I enter only the specific file of access it will not give me a msgbox box regarding changes that I did in a append queries or delete q. and when I exit the program it will define the access to the defaults of access.

I know how to do it by the menu but I what to do it in the "code"..

how do it define it ??? and in what event ???
 
Are you referring to a MsgBox you created or one of the windows popup messages?
 
if you use a command button you can add the following code to the click event of the button.

Code:
Docmd.setwarnings(False) ' Hides the msgbox's
Docmd.openquery "yourqueryname"  ' opens your query
docmd.setwarnings(True)  ' Sets access warnings back to default

HTH

Andy
 
you could also use the .Execute method which does not issue the warnings
 

Users who are viewing this thread

Back
Top Bottom