Open Report Design View As Hidden

[James]

Is their a way to open a report in design view as hidden?

[Ofer]

Try this code

DoCmd.OpenReport "ReportName", acViewDesign
Application.Reports("ReportName").Visible = True
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Post by James
Is their a way to open a report in design view as hidden?

[Dirk Goldgar]

Post by James
Is their a way to open a report in design view as hidden?

Sure:

DoCmd.OpenReport "Report1", acViewDesign, , , acHidden

[Ofer]

Are you sure about this option?
I didnt get any acHidden option on the OpenReport command line.
On the form Yes, but not in the report

Post by Dirk Goldgar

Post by James
Is their a way to open a report in design view as hidden?

DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

[Dirk Goldgar]

Post by Ofer
Are you sure about this option?
I didnt get any acHidden option on the OpenReport command line.
On the form Yes, but not in the report

It's most definitely there in Access 2002, as I tested it before
posting.

[Ofer]

You right
2003 has it
2000 doesn't have it
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Post by Dirk Goldgar

Post by Ofer
Are you sure about this option?
I didnt get any acHidden option on the OpenReport command line.
On the form Yes, but not in the report

It's most definitely there in Access 2002, as I tested it before
posting.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

[James]

the acHidden is not available for the OpenReport, only the OpenForm

Post by Dirk Goldgar

Post by James
Is their a way to open a report in design view as hidden?

DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

[Ofer]

Did you have any problem using my suggestion?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Post by James
the acHidden is not available for the OpenReport, only the OpenForm

Post by Dirk Goldgar

Post by James
Is their a way to open a report in design view as hidden?

DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

[Brendan Reynolds]

It works for me, in Access 2003. Perhaps it did not in earlier versions - I
don't have an earlier version installed on this PC, so can't test that right
now.

If it isn't supported in your version of Access, try Ofer's suggestion of
setting the Visible property - it should work too.
--
Brendan Reynolds

Post by James
the acHidden is not available for the OpenReport, only the OpenForm

Post by Dirk Goldgar

Post by James
Is their a way to open a report in design view as hidden?

DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

[Dirk Goldgar]

Post by James
the acHidden is not available for the OpenReport, only the OpenForm

What version of Access are you using? It's there in Access 2002.

[Jeff Conrad]

Not there in 97.

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

[Ofer]

It's not in 2000 either
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Post by Jeff Conrad
Not there in 97.
DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

Post by Dirk Goldgar
What version of Access are you using? It's there in Access 2002.

[fredg]

Post by James
Is their a way to open a report in design view as hidden?

DoCmd.OpenReport "ReportName", acViewDesign, , , acHidden