 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007How to display OpenStoredProcedure result set in child window
Hi, I'm using Access 2003 and using the OpenStoredProecedure method from VBA. I need to display th result set from this in a child window inside a form in the application. This does not happen automatically and now the result set displays in an independent window sitting out there. How do I make it a child window? Thanks. Eaton > Hi, I'm using Access 2003 and using the OpenStoredProecedure method from VBA. > I need to display th result set from this in a child window inside a form in > the application. This does not happen automatically and now the result set > displays in an independent window sitting out there. How do I make it a child > window? Thanks. Eaton why not set the rowsource of the form to the SP? Won't that work? If you have to, pass the PK from the parent form and get a filtered subset of data and make that the rowsource for the subform... hi, No, t hat won't work because the sp creates a variabel number of columns. There ought to be some way of making this window a child window of another form or something, right? Thanks. > > Hi, I'm using Access 2003 and using the OpenStoredProecedure method from VBA. > > I need to display th result set from this in a child window inside a form in [quoted text clipped - 5 lines] > you have to, pass the PK from the parent form and get a filtered > subset of data and make that the rowsource for the subform... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.