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

    Expand Collapse

    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.



    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???

    Van T. Dinh
    MVP (Access)

    "Martin" <lajitong888@21cn.com> wrote in message
    > 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