Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    Unanswered: button to start query automaticly in pivot table view

    Hello,

    I need some quick help for a button in Access.

    The button needs to display a querie in pivot table view !

    I changed the querie itself to display standard pivot table view.
    But making a button in a form linking to that querie doesn't display it in pivot table ??

    Can you help ?
    If possible as quick as possible ?

    many many tx !!

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    More information

    "I changed the querie itself to display standard pivot table view."

    What do you mean by this?

    Do you mean that you created a form with the query as the recordsource for the pivot on the FORM?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Jan 2004
    Posts
    5
    no, the form only contains a button linked to the query

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Clarification

    I am sorry, you do not seem to understand the nature of my question.

    You said in your original thread:

    "I changed the querie itself to display standard pivot table view."

    What do you mean by this?

    Also

    What version of Access are you working with?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Zip db

    If your .db is small enough, zip it and post here as an attachment
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  6. #6
    Join Date
    Jan 2004
    Posts
    5
    hmm my english seems to rust

    I have a db containing a form,of course, with data in a table.
    In that same db I have a querie in the section 'object - quiries' named 'querieImade' based on that data.
    I managed, when clicking on 'QuerieImade' to let it display in Pivot table instead of Datatable (we are still in 'objects' ...).

    Back to my form : I inserted a button wich starts the 'querieImade'. But when clicking on that button, it displays the query in datatable view ?
    can we change the default view when clicking my button.

    Access 2003

    Hope this helps

  7. #7
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Unhappy Thanks for reply

    Thanks for reply, but I am afraid I do not use Access 2003.

    I am sorry I can't help further, but I am sure that someone on this group uses 2003 and will be able to help.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  8. #8
    Join Date
    Jan 2004
    Posts
    5
    anyway ... how would you have done it in 2000 or 2002 ?

    Tx a lot

  9. #9
    Join Date
    Jan 2004
    Posts
    5
    How stop the thread I found the solution in the code :

    DoCmd.OpenQuery stDocName, acViewPivotTable, acEdit


    Tx a lot man

  10. #10
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    2000

    If you create a pivot table using the wizard (I think! I use Excel Automation for mine) it creates a FORM for the pivot table.

    "Pivot queries" as you are describing them must be a new feature

    Had it been 2000, I would have coded the button somehting like this;

    docmd.openform "NameOfFormWithPivotTableOn"
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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