Welcome to SPN

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

Sign Up Now!

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
     

Share This Page