How to Suppress an Access information message

[cmmrfrds]

I have a Function that does some deletes and inserts which pop up Access informational messages. I would like to suppress the messages for just this function. Can somebody tell me how to do it in the function.

Thank you,
Jerry

 

[ScottMusich]

Before the main part of your code add the following (Access 97 syntax):

DoCmd.SetWarnings False

Make sure after the code to set it back to True otherwise nothing will pop up from that point forward until Access is closed down. Scott Musich
Database Analyst/Programmer

 

[cmmrfrds]

Thank you. That did it in Access 2000 as well.

 

[ScottMusich]

No problem!

You can also acheive this by using Macros - However, I find it cleaner to use the code approach. Scott Musich
Database Analyst/Programmer