Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening Pivot (2003 (SP2))

    This may seem a silly request, but can anyone tell me how a pivot table form (or query) can be opened so it displays as a pivot table, from a button on another form?

    I've tried setting the default views to 'pivot table' but a form opens as a form & a query as a datasheet.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Opening Pivot (2003 (SP2))

    Use an instruction such as

    DoCmd.OpenForm "frmOrders", acFormPivotTable

    The second argument tells Access to open the form as a pivot table. If you omit this argument, the form will be opened in form view. It's similar for queries.

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Pivot (2003 (SP2))

    That's done it.

    Many thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •