<div>
Great, thanks! &nbsp;And so fast too :-)
</div>


<div>
13 minutes is slow for this forum...Glad I could help....Mike<br />

</div>


13 minutes is slow for this forum...Glad I could help....Mike


<div>
Hmm, how about:<br />
CurrentDb.Execute &quot;Exec MyStoredProcedure&quot;
</div>


Hmm, how about:
CurrentDb.Execute "Exec MyStoredProcedure"

<div>
&gt;&gt; Hmm, how about:<br />
&gt;&gt;&nbsp;CurrentDb.Execute &quot;Exec MyStoredProcedure&quot;<br />
<br />
Just for curiosity's sake I tried this too but it didn't work. &nbsp;Resulted in a MsgBox popup with a blank message.<br />
Thanks. &nbsp;The other solution may be clunkier but it works fine for me.
</div>


>> Hmm, how about:
>> CurrentDb.Execute "Exec MyStoredProcedure"

Just for curiosity's sake I tried this too but it didn't work.  Resulted in a MsgBox popup with a blank message.
Thanks.  The other solution may be clunkier but it works fine for me.

<div>
<div class="content wysiwyg-content">
In my ADP I have a form with button. &nbsp;When the button is clicked, a stored procedure is run that updates a table in the SQL Database. &nbsp;This is what I want it to do, and it works just fine. &nbsp; BUT, I also get a popup box that reads &quot;stored procedure executed but did not return records&quot;. &nbsp; &nbsp;Click OK and it goes away, but I'd prefer if it didn't appear at all, since I'm not expecting my stored procedure to return records.<br />
<br />
I'm calling the SP with DoCmd.OpenStoredProcedure<br />
<br />
Perhaps there is another way to call it so that it doesn't expect to return records?<br />
Or, is there a way to suppress the error message? &nbsp;I can't figure out what the error number is. &nbsp;I put in error handling code but it's not being caught by that.<br />
<br />
Thanks!
</div>
</div>


In my ADP I have a form with button.  When the button is clicked, a stored procedure is run that updates a table in the SQL Database.  This is what I want it to do, and it works just fine.   BUT, I also get a popup box that reads "stored procedure executed but did not return records".    Click OK and it goes away, but I'd prefer if it didn't appear at all, since I'm not expecting my stored procedure to return records.

I'm calling the SP with DoCmd.OpenStoredProcedure

Perhaps there is another way to call it so that it doesn't expect to return records?
Or, is there a way to suppress the error message?  I can't figure out what the error number is.  I put in error handling code but it's not being caught by that.

Thanks!

Stored procedure returns no records - handling error message.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.