Solved

MS Access StartUP (2010)

Posted on 2014-01-14
8
500 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 27

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 27

Expert Comment

by:MacroShadow
ID: 39778847
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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
 
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 27

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

766 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