Solved

MS Access StartUP (2010)

Posted on 2014-01-14
8
493 Views
Last Modified: 2014-01-14
I have created an application with a "Display Form" on startup, I have also unchecked the "Display Navigation  Pane". The application opens as expected but the Access icon remain in the top left hand corner with a pull down for customize toolbar.

How can I chang the settings that the tabs (File  & Home) and the above are not displayed?
0
Comment
Question by:Brogrim
8 Comments
 
LVL 26

Expert Comment

by:MacroShadow
ID: 39778829
You will have to use a custom Ribbon file.

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
  <qat> </qat>
  <tabs>
     <tab idMso="TabHome" visible="true" />
     <tab idMso="TabCreate" visible="true" />   
     <tab idMso="TabExternalData" visible="true" />
     <tab idMso="TabDatabaseTools" visible="true" />     
 </tabs>
</ribbon>
</customUI>

Open in new window


  <qat> </qat> is responsible for an empty Quick Access Toolbar.
0
 

Author Comment

by:Brogrim
ID: 39778840
Where does this code go, this is a desktop application
0
 
LVL 26

Expert Comment

by:MacroShadow
ID: 39778847
0
 

Author Comment

by:Brogrim
ID: 39778889
I have followed the link

1.    In the Customize the Ribbon window under the Customize the Ribbon list, click the tab that you want to remove.

2.    Click Remove.
    To see and save your customizations, click OK.

Thi has removed the Home tab bit I cant find the File tab to remove
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39778893
With 2010, you still have access to command bars and can remove the ribbion entirely with:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

also, in dealing with the ribbon, this site:

http://www.ribboncreator.de/en/

has a wealth of information on working with the ribbon.  Check the FAQ link on the left.

Jim.
0
 

Author Closing Comment

by:Brogrim
ID: 39778911
Thanks
0
 
LVL 26

Expert Comment

by:MacroShadow
ID: 39778914
You can't remove the File tab unless you create your own ribbon, for that see the link posted by Jim Dettman and the second link I posted.
0
 
LVL 75
ID: 39779872
"You can't remove the File tab unless you create your own ribbon"
Actually, you cannot remove the File tab no matter what. But you can remove everything on it.

mx
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now