How do you create a child window/form

[Guest]

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

 

[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.

 

[Guest]

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

 

[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.

 

[Guest]

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

 

[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