Open Report Design View As Hidden

[Guest]

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

 

[Guest]

Try this code

DoCmd.OpenReport "ReportName", acViewDesign
Application.Reports("ReportName").Visible = True

 

[Dirk Goldgar]

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

Sure:

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

 

[Guest]

Are you sure about this option?
I didnt get any acHidden option on the OpenReport command line.

 

[Guest]

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

 

[Guest]

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

 

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

 

[Dirk Goldgar]

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

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

 

[Dirk Goldgar]

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.

 

[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

in message:

 

[Guest]

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

 

[Guest]

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

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

in message:

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

 

[fredg]

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

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