Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table A97 (Access 97 SP3)

    Client reports that his Access 97's pivot table form function doesn't work. Apparently the form pops up but Pivot Table doesn't launch. Client reports using Essbase but is not sure if the pivot table function worked prior to addition of Essbase and the last change made was install of Essbase or if there was a security patch applied.

    Sorry for the lack of info on this. Will try to get details for a follow up post.

    Thanks,
    Jester
    I know enough to know I don't know enough

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

    Re: Pivot Table A97 (Access 97 SP3)

    Please try to get specific information. I don't even know what "pivot table form function" is.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Pivot Table A97 (Access 97 SP3)

    Access 97 (and 2000) don't have a pivot table function of any kind - the only option is to use CrossTab queries. Access XP added the pivot table and form capability.
    Wendell

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table A97 (Access 97 SP3)

    As I said, I will try to get details. This is not Office XP as the Access in shop is 97 and 2K. Apparently there is some link (DDE or 3rd party app) that pulls or pushes the data from/to an Excel spreadsheet hence the pivot table reference.

    -Jester
    I know enough to know I don't know enough

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Pivot Table A97 (Access 97 SP3)

    That could well be - the developer may have used Automation to push data to an Excel pivot table as Excel has had that capability longer.
    Wendell

Posting Permissions

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