don't want to show message box

[anwardada]

hi in access when i use append query i see this message "your are about to run a append query that will modify your table " i don't wanna show this mesage because i am using vba userform to call this append query so please tell me the solution

regards
anwar khan

 

[boblarson]

In your code, use this before the code that runs the query:

DoCmd.SetWarnings(False)

and then remember to put this right after the code that runs the query

DoCmd.SetWarnings(True)

and you should put an error handler in and then put the one that sets it true in the error handler as well. Because, if you don't, you could wind up with no error messages showing up, ever again if the query doesn't run and generates an error. Then, you won't get save confirmations, etc.

 

[anwardada]

thanks alot it works
regards anwar

In your code, use this before the code that runs the query:

DoCmd.SetWarnings(False)

and then remember to put this right after the code that runs the query

DoCmd.SetWarnings(True)

and you should put an error handler in and then put the one that sets it true in the error handler as well. Because, if you don't, you could wind up with no error messages showing up, ever again if the query doesn't run and generates an error. Then, you won't get save confirmations, etc.

 

[anwardada]

thanks alot it realy works

 

[Moniker]

Also, note that using CurrentDb.Execute "YOUR SQL HERE" bypasses the warning messages as well, and you don't have to remember to do the DoCmd.SetWarnings stuff each time you want to skip the built-in warning messages.