Results 1 to 3 of 3
  1. #1
    kotzo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    4

    Creating query shortcuts on desktop but maintaining the pivot view as initial view

    Dear all,

    Hopefully a simple question:

    I have created a query that opens in access by default in pivot view.
    Now I'm trying to create a query desktop shortcut for that query that has also by default the pivot view.

    Unfortunately, this is not working.

    By clicking on the shortcut, the query opens in datasheet view.

    Is it possible to change that ?

    I tried to edit the query shortcut but it's not editable.

    I would appreciate any help !

    Regards,



    K. Tzovanis

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    well - a desktop short cut would open the application overall

    make a macro named : autoexec

    have that macro open the query

    have the query designed to be a cross tab query

  3. #3
    kotzo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    4
    Thanks,

    I'll try

    Regards

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-09-2014, 03:21 PM
  2. Replies: 5
    Last Post: 07-17-2013, 08:35 PM
  3. Replies: 3
    Last Post: 03-25-2013, 02:01 PM
  4. Replies: 0
    Last Post: 11-30-2011, 02:01 PM
  5. Query default to Pivot Table view
    By Theremin_Ohio in forum Access
    Replies: 1
    Last Post: 03-30-2011, 09:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums