G
Guest
Is their a way to open a report in design view as hidden?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Try this code
DoCmd.OpenReport "ReportName", acViewDesign
Application.Reports("ReportName").Visible = True
DoCmd.OpenReport "ReportName", acViewDesign
Application.Reports("ReportName").Visible = True
D
Dirk Goldgar
James said:Is their a way to open a report in design view as hidden?
Sure:
DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
G
Guest
Are you sure about this option?
I didnt get any acHidden option on the OpenReport command line.
I didnt get any acHidden option on the OpenReport command line.
G
Guest
the acHidden is not available for the OpenReport, only the OpenForm
G
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
--
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
B
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.
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.
D
Dirk Goldgar
James said:the acHidden is not available for the OpenReport, only the OpenForm
What version of Access are you using? It's there in Access 2002.
D
Dirk Goldgar
Ofer said: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.
J
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:
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:
G
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
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
G
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
--
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
Jeff Conrad said: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.
F
fredg
Is their a way to open a report in design view as hidden?
DoCmd.OpenReport "ReportName", acViewDesign, , , acHidden
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.