How do you create a child window/form

E

Eaton

Hi,

I have a result set from OpenView or OpenStoredProcedure which displays in a
window, but it's not contained within another form. (I need to use OpenView
or OpenStoredProcedure because the number of columns will be changing.)
How do I make this a child form or window that will be contained within a
parent form?

Thanks.
Eaton
 
D

Douglas J. Steele

Create a form to hold the results.

Open the parent form in design view, and drag the form you created above
onto the parent form from the database window.
 
E

Eaton

Hi Doug,

This is all happening in a VBA script, not design mode. I run
OpenStoredProcedure, the result set comes back in a window and I want to
contain that result set window within a parent window.
There's got to be a way, right?

Thanks.
Eaton
 
D

Douglas J. Steele

Rather than use OpenStoredProcedure, create a pass-through query and use it
as the RecordSource for a form you use as a subform.
 
E

Eaton

Hi,

As an fyi, I'm using an Access 2003 .adp; the stored procedure I am running
creates a varying number of columns in the result set; each time it is run,
there could be a different number of columns returned; that's the only reason
I'm using OpenStoredProcedure because it will at least open a result set
window showing each unique result set, otherwise, I would use a regular form.
Using a regular form would not work with a variable number of columns or
would not show them, right? If you have another idea for displaying this
variable column result set, please let me know.

Thanks.
Eaton
 
D

Douglas J. Steele

Since you're using an ADP, I'd suggest posting to the ADP group
(microsoft.public.access.adp.sqlserver)

If Microsoft abyssmal web interface doesn't provide access to that newsgroup
and you don't want to use a news reader, go through http://groups.google.com
 
Top