Welcome to SPN

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

Sign Up Now!

Re: How to show the "fields list button" , by VBA ?

Discussion in 'Information Technology' started by Martin, Nov 18, 2005.

  1. Martin

    Martin
    Expand Collapse
    Guest

    Because I developed a system, when open, I use the Access settings to hide
    all the small buttons.

    However, I want the users to be able to use the "field list" button in the
    PIVOT VIEW ( acFormPivotTable), so that they can use the "field list" button
    to easily create different kinds of PIVOT reports as they like.

    I am now badly in need of a VBA sentence to get the "fields list" button
    availble to the user.

    Martin


    -----------------------------------------------------------------

    There is, indeed, a "Field List" button in the "Form Design" Toolbar (and
    the Menu View / Field List) but this is only available (appropriately so) in
    the *DesignView* of the Form.

    Why would you want the "Field List" button available in the opening of the
    NormalView (operating view) of the Form???

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Martin" <lajitong888@21cn.com> wrote in message
    news:er14Op06FHA.3048@TK2MSFTNGP10.phx.gbl...
    > At first, I use VBA to hide all the bars and small buttons.
    >
    > I am now want to show the "fields list button" ( I don't know exactly the
    > English is ) when I open a FORM at the FORM'S opening event.
    >
    > Please tell me what should the VBA is?
    >
    > I have tried, by failed. Application.CommandBars("Form/View
    > Design").Controls(1).Visible = True
    > also, I am not sure wheater the "fields list samll button" is
    > CommandBars("Form/View Design").Controls(1)
    >
    >
    > Thank you very much!
    >
    >
     
  2. Loading...


Share This Page