[AccessD] ADP/SP problem

Susan Geller sgeller at cce.umn.edu
Mon Aug 11 16:34:07 CDT 2003


Michael,

I know what I would do if you were in an unbound form, but I'm not sure
what to tell you with bound.  If you haven't gotten any other ideas, I
can send you that and you can try to work with it.  Let me know.

--Susan

-----Original Message-----
From: Michael Brosdorf [mailto:michael.broesdorf at web.de] 
Sent: Thursday, August 07, 2003 3:51 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] ADP/SP problem


Hello,

in my ADP-project (A2K) I have a (read-only) subform that is bound to a
stored procedure with an input parameter. The input parameter uses a
textbox on the main form. That works fine as long as the SP returns
records. However, if the SP does not return records, Access displays a
message telling me that the SP has been executed but did not return any
records. I click on OK and the same message reappears over and over
again. I can only end this by 'killing' access using the task manager of
Windows.

How can I tell Access not to tell me that no records are returned by the
SP?

TIA,

Michael

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list