Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6445
  • Last Modified:

Access 2013 : How To Hide Ribbon, File, Quick Access Toolbar and Sign In when Access starts

Is there a way to hide the Ribbon, the File menu, the Quick Access Toolbar and Sign In when Access 2013 starts?

All the old ways (pre 2010) seem to have been disabled.
0
machine_run
Asked:
machine_run
1 Solution
 
datAdrenalineCommented:
In 2013 the ability to use the old style menus/toolbars has been removed, so the ribbon is the only way to go for a custom ui experience (barring custom form objects).  However, I believe you manage the visibility of the RibbonUI object with ...

To hide the Ribbon:
DoCmd.ShowToolbar "Ribbon", acToolbarNo

Open in new window


To show it again ...

DoCmd.ShowToolbar "Ribbon", acToolbarYes

Open in new window


For a list of all the 2013 deprecated features check out ...
http://technet.microsoft.com/en-us/library/cc178954(v=office.15).aspx
0
 
Bill RossCommented:
Hi,

This question has popped up several times.  Try this post:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28158530.html

Regards,

Bill
0
 
Nick67Commented:
How seriously do you want to go after this?

MS hasn't made it easy.  If you are looking to reclaim all the space the Ribbon occupies and replace it with a toolbar of your own making, no that isn't going to happen.
If you want to remove almost all the functionality that the Ribbon flops out there, then yes, there are many steps -- with a lot of picky XML code -- that can be taken to lock most things down.

There is a huge discussion of it here
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27231448.html
That gets into many of the nuts and bolts of complete disablement

There's another, more recent discussion of it here
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28140895.html

An essential time-saving tool is here
http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/06/7293.aspx

It permits you to parse that finicky XML to ensure that it is 'well-formed'  The XML is case-sensitive and not tolerant of much deviation from spec.

The latest discovery is that there is a <command></command> set of tags that can be put in the XML to seize the event of buttons you cannot manage to hide, so they don't do actions you wouldn't like.

Easiest places to start are by CAREFULLY backing up your file, converting it to an .accde, and renaming it to .accdr  Have a look at what remains of the Ribbon -- it may be enough lock down for you!

As for hide sign-in, that is so new that I haven't seen any discussion of how to hide/disable THAT.  I suspect you won't be able to.

Happy reading!
0
 
machine_runAuthor Commented:
Thanks! Very frustrating Microsoft restrictions.
0
 
Nick67Commented:
It has been 6 years since the Ribbon was released.  Slowly, the documentation needed to do stuff with the Ribbon has trickled out and been collated.  Gunter has posted good stuff on his site
http://www.accessribbon.de/en/
and slowly listings of all the icons, all the control names and all the events have trickled into the MS knowledge base.  It isn't so much that MS has restricted things, as they have made things extremely opaque.  The standalone MS Access developer of Access 97-2003 apps has been pretty much left standing at the altar by MS.  MS wants you to throw away VBA and standalone apps and embrace SharePoint.  Instead of locking down your UI, they want you to lock down the file and the data -- and so they have never provided a lot of detailed, good guidance about the UI in Access.

Shameful, really.
Sigh.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now