I have a MS Access 2003 application and the users need the ability to design
their own reports. I have 3 popup, modal forms...frm_main_menu,
frm_administration and frm_reports. On the frm_reports form I have a command
button with the following code:
DoCmd.RunCommand acCmdNewObjectReport
DoCmd.Close acForm, "frm_reports"
DoCmd.Close acForm, "frm_administration"
DoCmd.Close acForm, "frm_main_menu"
This opens the new report wizard and closes all the open forms.
My problem is after they are done creating the new report and closing the
design view I would like to be able to automatically reopen the form
frm_main_menu.
Is their a way to do this? Thanks.

"James" <(E-Mail Removed)> wrote in message
news:549EE1F2-3CDB-4172-8514-(E-Mail Removed)...
>I have a MS Access 2003 application and the users need the ability to
>design
> their own reports. I have 3 popup, modal forms...frm_main_menu,
> frm_administration and frm_reports. On the frm_reports form I have a
> command
> button with the following code:
> DoCmd.RunCommand acCmdNewObjectReport
> DoCmd.Close acForm, "frm_reports"
> DoCmd.Close acForm, "frm_administration"
> DoCmd.Close acForm, "frm_main_menu"
> This opens the new report wizard and closes all the open forms.
> My problem is after they are done creating the new report and closing the
> design view I would like to be able to automatically reopen the form
> frm_main_menu.
> Is their a way to do this? Thanks.
>
>

Why not just keep "frm_main_menu" open?

Keith.

I cannot keep the frm_main_menu open because it goes in front of the design
view, so I need to close it (or hide it.) But either way, when the design
view is closed the form will then have to open or become visible.


"Keith Wilby" wrote:

> "James" <(E-Mail Removed)> wrote in message
> news:549EE1F2-3CDB-4172-8514-(E-Mail Removed)...
> >I have a MS Access 2003 application and the users need the ability to
> >design
> > their own reports. I have 3 popup, modal forms...frm_main_menu,
> > frm_administration and frm_reports. On the frm_reports form I have a
> > command
> > button with the following code:
> > DoCmd.RunCommand acCmdNewObjectReport
> > DoCmd.Close acForm, "frm_reports"
> > DoCmd.Close acForm, "frm_administration"
> > DoCmd.Close acForm, "frm_main_menu"
> > This opens the new report wizard and closes all the open forms.
> > My problem is after they are done creating the new report and closing the
> > design view I would like to be able to automatically reopen the form
> > frm_main_menu.
> > Is their a way to do this? Thanks.
> >
> >
>
> Why not just keep "frm_main_menu" open?
>
> Keith.
>
>

"James" <(E-Mail Removed)> wrote in message
news:FD74BD34-CEFF-484A-AE39-(E-Mail Removed)...
>I cannot keep the frm_main_menu open because it goes in front of the design
> view,

Why is that? Might it be a popup/modal issue which you can change so that
the report design view goes in front?

> so I need to close it (or hide it.) But either way, when the design
> view is closed the form will then have to open or become visible.
>

Events only fire at runtime and not in the design environment. If they did
then it would be chaos for the developer. Allowing end users the ability to
design is always going to be fraught with difficulties, I would suggest
giving them another "open" front end (ie the db window is visible) with
read-only permissions to the data but with design permissions on new
reports.

Regards,
Keith.

It is a popup/modal issue - by design the forms are set to popup and modal.
they stay in front of the design view.

"Keith Wilby" wrote:

> "James" <(E-Mail Removed)> wrote in message
> news:FD74BD34-CEFF-484A-AE39-(E-Mail Removed)...
> >I cannot keep the frm_main_menu open because it goes in front of the design
> > view,
>
> Why is that? Might it be a popup/modal issue which you can change so that
> the report design view goes in front?
>
> > so I need to close it (or hide it.) But either way, when the design
> > view is closed the form will then have to open or become visible.
> >
>
> Events only fire at runtime and not in the design environment. If they did
> then it would be chaos for the developer. Allowing end users the ability to
> design is always going to be fraught with difficulties, I would suggest
> giving them another "open" front end (ie the db window is visible) with
> read-only permissions to the data but with design permissions on new
> reports.
>
> Regards,
> Keith.
>
>