Re: How do you create a child window/form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Eaton" <Eaton@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BA664E3A-00A6-4AA2-B6C4-803FB794A752@xxxxxxxxxxxxxxxx
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" wrote:

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Eaton" <Eaton@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:33B8AD30-45ED-4335-9DAF-BC4295DA1E4A@xxxxxxxxxxxxxxxx
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






.

Relevant Pages

  • Re: going back from Access 2003 to Access 97?
    ... > If your database window is open, but you can't see anything then try ... > The file window you mention is asking you to select an existing dbs. ... >> Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: How do you create a child window/form
    ... Since you're using an ADP, I'd suggest posting to the ADP group ... Doug Steele, Microsoft Access MVP ... the result set comes back in a window and I want ...
    (microsoft.public.access.forms)
  • Re: Update textbox from option group
    ... Doug Steele, Microsoft Access MVP ... The "frmActionPlantest" is the parent form, ... txtOptionSummary is the textbox on the parent form. ...
    (microsoft.public.access.formscoding)
  • Re: How do you create a child window/form
    ... Rather than use OpenStoredProcedure, create a pass-through query and use it ... Doug Steele, Microsoft Access MVP ... the result set comes back in a window and I want to ... Open the parent form in design view, and drag the form you created above ...
    (microsoft.public.access.forms)
  • Re: dlookup
    ... how WOULD I refer to a control on a subform ... > on a parent form? ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)