none
How to Turn Off All Menus, Ribbons, etc. RRS feed

  • Question

  • First, please excuse if I'm asking a question that's been asked several times before, but I've looked at all the suggested threads and cannot find an answer.

    I've developed an Access 2010 application that the user will open in runtime mode. I want the application to show NO menus, ribbons, QAT, or anything that's native to Access. All navigation and functionality works within the forms of the application.

    I've been able to do this in previous versions of Access (2003), but for the life of me I can't find the settings or methods to do this in Access 2010. No matter what I try, the application opens showing the main menu bar, the ribbon, and the QAT. Am I being naïve? It seems like such a simple thing to want to do--to have an application open so that it looks totally self-contained and not just an instance of Access.

    TIA for any help and suggestions.

    Tuesday, July 8, 2014 6:51 PM

Answers

  • Hi Mike,

    If you want to start over with a clean Access 2010 database file, you could create a blank database using Access 2010 and then import all the objects from your old database. Since you'll be manually selecting which objects to import, you should be able to pick only those you really want to keep.

    Just a thought...

    Wednesday, July 9, 2014 7:20 PM
  • 1) Your tip, DBG, about changing the extension to .accdr...

    2) Now my problem is how to remove that custom menu ...

    1) I think I was the one who gave you that tip

    2) Can you disable the Add-ins through: File\ Options\ Add-ins

    Select the type of Add in and press go and then remove it from the list?


    Chris Ward

    Wednesday, July 9, 2014 7:53 PM

All replies

  • Good Afternoon MDS,

    Not too hard. Look Under File, Options, Current Database and do the following

    1. Uncheck Use Access Special Keys
    2. Radio Dial Use Overlapping Windows (unless you really need otherwise)
    3. Uncheck Display Navigation Pane
    4. Uncheck Allow Full Menus
    5. Uncheck Allow Default Shortcut Menus

    Next create an AutoKeys Macro to program the {F-11} key to Something other than un-hiding the Navigation Pane.

    Create an Autoexec Macro to Open your MainForm in Normal View(or open all Forms and just switch between them). In the Macro add this line of Code

          DoCmd.ShowToolbar "Ribbon", acToolbarNo

    I recommend having a hidden Click or Double Click Event to do the opposite in case of an oops, you can remove it just before creating the Runtime

          DoCmd.ShowToolbar "Ribbon", acToolbarYes

    Next if you feel you need to keep prying eyes out you should create a Module to Disable Shift Key at startup. If you are not worried about savvy users then this should do about what you need unless I forgot something.

    Hth


    Chris Ward

    Tuesday, July 8, 2014 9:17 PM
  • Hi,

    You said that the users will be using the Runtime version. If so, I believe they won't see any of the menu you're seeing because you have the full version of Access.


    • Edited by .theDBguy Tuesday, July 8, 2014 11:52 PM
    Tuesday, July 8, 2014 11:51 PM
  • You said that the users will be using the Runtime version. If so, I believe they won't see any of the menu you're seeing because you have the full version of Access.

    Good Morning DB guy,

    1. There is no guarantee that users can not have Access, and if they do they will see everything as the OP sees it.
    2. The question by the OP is how to completely hide the entire Ribbon & QAT & any menu (I'm guessing this includes the Back Stage "FILE") Therefore the OP will need at least what I suggested above.
    3. You can simulate what the Runtime version will look like by changing the extension of an .accdb to .accdr and while most items are removed, the FILE menu and the QAT remain on the left, and on the right, Account access and the help improve office links.

    Hth


    Chris Ward

    Wednesday, July 9, 2014 1:20 PM
  • You said that the users will be using the Runtime version. If so, I believe they won't see any of the menu you're seeing because you have the full version of Access.

    Good Morning DB guy,

    1. There is no guarantee that users can not have Access, and if they do they will see everything as the OP sees it.
    2. The question by the OP is how to completely hide the entire Ribbon & QAT & any menu (I'm guessing this includes the Back Stage "FILE") Therefore the OP will need at least what I suggested above.
    3. You can simulate what the Runtime version will look like by changing the extension of an .accdb to .accdr and while most items are removed, the FILE menu and the QAT remain on the left, and on the right, Account access and the help improve office links.

    Hth


    Chris Ward

    Hi Chris,

    Hope I didn't offend you. Of course there's no guarantee since we both have no visibility to the OP's environment. You even said it yourself, there's no guarantee that what you provided would stop the "savvy" users.

    I was just hoping to present a different point of view in case it's applicable to the OP's situation. If not, no harm done because you've already provided what's needed. If that's not acceptable here, then I apologize.

    Thanks,

    DBG

    Wednesday, July 9, 2014 2:50 PM
  • Good Morning DB guy,

    Not offended at all, just explaining the requirements for the OP's needs based on the specific question "I want the application to show NO menus, ribbons, QAT, or anything that's native to Access"

    I do not object to your comments however, your suggestion does not satisfy the OP's question in this case.

    Cheers


    Chris Ward

    Wednesday, July 9, 2014 3:59 PM
  • Good morning Chris and DBG,

    Thanks for both of your suggestions. I had already tried all of your tips, Chris, and they didn't work. (I checked my code to verify that I had done them all.) I had also already set up a module to toggle Disable Shift Key.

    Your tip, DBG, about changing the extension to .accdr, was new to me. I tried it and it "sort of" worked. All of the menu bar disappeared except one tab named File. That shook my brain enough to realize that I left out a very important detail in my original post that I didn't realize was relevant at the time. Namely, this app was converted from an Access 2003 app that I wrote several years ago. And in that app, I had created a custom menu called File and set the opening options to display that menu instead of the default. I'm sure that's the root of all my problems. When I converted the app to Access 2010, that old code was included.

    Now my problem is how to remove that custom menu from the Access 2010 app and go back to the default menus. If I can do that, then your suggestions will probably work. I will post again after I play with this for a while. Meanwhile, if you have any suggestions for how to wipe out that old custom menu bar, I would appreciate it.

    Thanks again,

    Mike Storms

    Wednesday, July 9, 2014 5:22 PM
  • Hi Mike,

    If you want to start over with a clean Access 2010 database file, you could create a blank database using Access 2010 and then import all the objects from your old database. Since you'll be manually selecting which objects to import, you should be able to pick only those you really want to keep.

    Just a thought...

    Wednesday, July 9, 2014 7:20 PM
  • 1) Your tip, DBG, about changing the extension to .accdr...

    2) Now my problem is how to remove that custom menu ...

    1) I think I was the one who gave you that tip

    2) Can you disable the Add-ins through: File\ Options\ Add-ins

    Select the type of Add in and press go and then remove it from the list?


    Chris Ward

    Wednesday, July 9, 2014 7:53 PM
  • 1) Your tip, DBG, about changing the extension to .accdr...

    1) I think I was the one who gave you that tip


    Chris Ward

    Hi Mike,

    Chris is right! I don't want to take credit for something I didn't do. Cheers!

    Wednesday, July 9, 2014 8:00 PM
  • My apologies, Chris. You were the one who posted that suggestion--I was careless in my attribution. I thank you again. It is one of those little gems I was not aware of and will definitely use in the future.
    Wednesday, July 9, 2014 8:01 PM
  • Thanks to both of you, Chris and DBG. I ended up taking the route suggested by DBG to create a new empty Access 2010 database and move all the objects from the old application into it. Worked like a charm. I will also be using the .accdr tip from Chris to make sure the app will execute in runtime mode even on computers that have Access installed.

    Mike

    Monday, July 14, 2014 6:30 PM
  • Hi Mike,

    Congratulations! Glad to hear you got it all sorted out.

    We're happy to assist. Good luck with your project.

    Monday, July 14, 2014 7:01 PM
  • Glad you have a resolution.

    Since you went with DBG's solution you may wish to consider marking his post as the Answer.


    Chris Ward


    • Edited by KCDW Monday, July 14, 2014 7:57 PM
    Monday, July 14, 2014 7:55 PM