Results 1 to 4 of 4
  1. #1
    ezz is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2014
    Location
    Over the Hills and Far Away
    Posts
    16

    How to hide Access Options button?


    Hello!

    I want to hide the Access Options button, as well as the ribbon and Office button, so that the end-user is left with an interface that looks like an application and have access only to the forms and reports.
    Click image for larger version. 

Name:	access1.png 
Views:	11 
Size:	184.7 KB 
ID:	18826

    I built a tabled named USysRibbons and entered the following XML code:

    <CustomUI xmlns="https://schemas.microsoft.com/office/2006/01/CustomUI"> <ribbon startFromScratch="true"/> </CustomUI>
    Click image for larger version. 

Name:	access2.png 
Views:	11 
Size:	295.7 KB 
ID:	18827
    I then chose the field name from the Access Options button, closed the database, and when I reopened it, it gives me many error messages. When I click Okay so that error messages disappear, I find that the Access Options button has been gone.
    Click image for larger version. 

Name:	access3.png 
Views:	11 
Size:	78.0 KB 
ID:	18828
    However, when I click on the small blue arrow up there, it opens a drop-down menu with an option to open the Access Options button.
    Click image for larger version. 

Name:	access4.png 
Views:	11 
Size:	166.4 KB 
ID:	18829
    How can I disable that option too? I don't want the end user to have access to all these options. I don't want them to appear on the interface.

    Thank you in advance.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,932
    Post rest of the custom ribbon XML code.
    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
    ezz is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2014
    Location
    Over the Hills and Far Away
    Posts
    16
    Quote Originally Posted by June7 View Post
    Post rest of the custom ribbon XML code.
    This is the whole code. Got it from support.office
    I know, it seems short. I tried longer ones but the same problem keeps on happening.

    Could you suggest a better working code that disables the option from the drop-down list, too?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,932
    Did you review the links I posted in your other thread? It shows the XML code I use.
    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.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-27-2013, 12:49 PM
  2. Replies: 3
    Last Post: 11-18-2012, 12:49 PM
  3. Access Options Button
    By 95DSM in forum Programming
    Replies: 1
    Last Post: 08-16-2010, 03:05 PM
  4. Replies: 1
    Last Post: 06-20-2010, 05:04 AM
  5. Toggle Button Options
    By Matthieu in forum Forms
    Replies: 2
    Last Post: 11-23-2009, 04:05 PM

Tags for this Thread

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 - Senior Forums