Results 1 to 5 of 5
  1. #1
    phi.21st is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    5

    Custom Ribbon Problem: always change back to the first tab

    Hi All,



    I have a problem with custom ribbons.

    Let's say I have a ribbon with 2 tabs: Tab 1, and Tab 2.
    From tab 2, I can open a form, and from this form I can "Print" or "Preview" a report.

    The problem is, when I close the report preview by clicking the "Close Print Preview" button, it always goes back to the first tab of my ribbon (Tab 1). While what I want is, it goes back to the Tab 2.

    Any suggestions?

    Thanks,
    phi.21st

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Tab 2 is available - just doesn't have focus? Would have to see the code that sets up the custom ribbon. Do you want to provide the project?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    phi.21st is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    5
    yes, tab 2 is available. and can be activated/ set focus by using this code:

    gobjRibbon.ActivateTab "idOfTab2"

    But i have no idea how to get the id of current active tab.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Check out the resources here http://www.wordarticles.com/Shorts/R...bonVBADemo.php

    Go to the last paragraph.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    phi.21st is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    5
    i have also checked that resource, but unfortunately, i could not find the solution of my problem there.

    i think i will manually look into my table to get the id of my current active tab (i know this is not an efficient way)

    anyway, June7, thanks for your help, really

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

Similar Threads

  1. Custom Ribbon
    By nkuebelbeck in forum Programming
    Replies: 5
    Last Post: 08-25-2011, 11:55 AM
  2. Put an icon in a custom ribbon
    By ss3373 in forum Access
    Replies: 0
    Last Post: 06-21-2011, 05:52 AM
  3. Replies: 0
    Last Post: 03-25-2011, 03:35 PM
  4. Custom error message problem
    By thekruser in forum Programming
    Replies: 10
    Last Post: 10-06-2010, 05:14 PM
  5. Replies: 0
    Last Post: 02-02-2010, 01:43 PM

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