Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Open Report Design View As Hidden

Discussion in 'Information Technology' started by James, Nov 2, 2005.

  1. James

    James
    Expand Collapse
    Guest

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


  3. Ofer

    Ofer
    Expand Collapse
    Guest

    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



    "James" wrote:

    > Is their a way to open a report in design view as hidden?
     
  4. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "James" <James@discussions.microsoft.com> wrote in message
    news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
    > Is their a way to open a report in design view as hidden?


    Sure:

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


    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  5. Ofer

    Ofer
    Expand Collapse
    Guest

    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


    "Dirk Goldgar" wrote:

    > "James" <James@discussions.microsoft.com> wrote in message
    > news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
    > > Is their a way to open a report in design view as hidden?

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

    James
    Expand Collapse
    Guest

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

    "Dirk Goldgar" wrote:

    > "James" <James@discussions.microsoft.com> wrote in message
    > news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
    > > Is their a way to open a report in design view as hidden?

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

    Ofer
    Expand Collapse
    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



    "James" wrote:

    > the acHidden is not available for the OpenReport, only the OpenForm
    >
    > "Dirk Goldgar" wrote:
    >
    > > "James" <James@discussions.microsoft.com> wrote in message
    > > news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
    > > > Is their a way to open a report in design view as hidden?

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

    Brendan Reynolds
    Expand Collapse
    Guest

    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

    "James" <James@discussions.microsoft.com> wrote in message
    news:E7D0A2CE-9F12-43BC-AF48-D4D25E21BF30@microsoft.com...
    > the acHidden is not available for the OpenReport, only the OpenForm
    >
    > "Dirk Goldgar" wrote:
    >
    >> "James" <James@discussions.microsoft.com> wrote in message
    >> news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
    >> > Is their a way to open a report in design view as hidden?

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

    Dirk Goldgar
    Expand Collapse
    Guest

    "James" <James@discussions.microsoft.com> wrote in message
    news:E7D0A2CE-9F12-43BC-AF48-D4D25E21BF30@microsoft.com
    > 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, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  10. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Ofer" <Ofer@discussions.microsoft.com> wrote in message
    news:B7919A35-FFE3-4A52-A6D0-8E0732EB5311@microsoft.com
    > 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)
     
  11. Jeff Conrad

    Jeff Conrad
    Expand Collapse
    Guest

  12. Ofer

    Ofer
    Expand Collapse
    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



    "Dirk Goldgar" wrote:

    > "Ofer" <Ofer@discussions.microsoft.com> wrote in message
    > news:B7919A35-FFE3-4A52-A6D0-8E0732EB5311@microsoft.com
    > > 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)
    >
    >
    >
     
  13. Ofer

    Ofer
    Expand Collapse
    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



    "Jeff Conrad" wrote:

    > 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
    >
    > "Dirk Goldgar" wrote in message:
    > news:u2KeCmy3FHA.2196@tk2msftngp13.phx.gbl...
    >
    > > What version of Access are you using? It's there in Access 2002.

    >
    >
    >
     
  14. fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 1 Nov 2005 11:42:11 -0800, James wrote:

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


    DoCmd.OpenReport "ReportName", acViewDesign, , , acHidden
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page