Supressing Access Project MsgBox after stored procedure executes

[traveller4]

In my project I have a form that loads when a command button is clicked on another form. As the form is loading it executes an INSERT INTO stored procdure. My problem is that every time the stored procedure finishes executing the I get a message box with a title of Microsoft Access stating: "Stored procedure executed but did not return records". The user has to click "OK' and the message box goes away. The records INSERT INTO the proper table, I just would prefer to turn off the message so the user doesn't see it. Is this possible or is this an Access Project feature.

Thanks in advance

Micheal

 

[dwlerwill]

Try this

DoCmd.SetWarnings = False ' Place at start of your procedure

DoCmd.SetWarnings = True ' Place at End of your procedure

This should work David Lerwill
"If at first you don't succeed go to the pub"

 

[traveller4]

David

Thanks for your advice. I am opening this form through a macro so it seems to ignore the Docmd.Setwarning. I even had put the Setwarning in the macro and it still doesn't stop the message box. Your suggestion works in an Access .mdb when calling the stored procedure, but doesn't work in Access Project.


Thanks again

Micheal