Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Apr 2006
    Location
    California
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom Ribbons (Access 2007)

    I'm slowly getting a handle on creating and using custom ribbons, but I'm still at a ver basic level. So far I've successfully created a ribbon to be used with applicaiton forms and a ribbon for use in print preview. However, I keep having the Navigation Pane expand after a ribbon change. I've used the Ribbon property in both forms and reports rather than code to load the proper ribbon. Any thoughts on how to keep the Navigation Pane minimized?

    Thanks in advance for any assistance.
    Marty

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Custom Ribbons (Access 2007)

    It sounds like you are way ahead of me in finding your way around 2007. But I have found this.

    DoCmd.RunCommand acCmdWindowHide

    In older versions of Access this hides the db window. In 2007 it hides the Navigation Pane.

    F11 will get it back again.
    Regards
    John



  3. #3
    Star Lounger
    Join Date
    Apr 2006
    Location
    California
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom Ribbons (Access 2007)

    John,

    Thanks for the input. Now I'll have to figure out all the events that will need that command. I was sort of hoping there was some XML that I overlooked.

    Marty

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Custom Ribbons (Access 2007)

    There may well be some XML that does the job as well.

    I just put DoCmd.RunCommand acCmdWindowHide in the onLoad event of my startup form, and keep the Navigation Panel permanently hidden.

    I provide all the navigation I want my users to use on the form I provide.
    Regards
    John



Posting Permissions

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