?
Solved

How to adjust the default ribbon for Microsoft Access 2007?

Posted on 2011-02-17
7
Medium Priority
?
359 Views
Last Modified: 2013-11-27
How do I adjust the ribbon that comes up when you initially open Microsoft Access 2007 application - before opening any databases at all?

See per image?

Thank you in advance.
EE-Ques.png
0
Comment
Question by:stephenlecomptejr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 6

Expert Comment

by:Cesar Aracena
ID: 34916166
Hi stephenlecomptejr,

I don't think you can. When you right click on that tabs bar, you are offered to customize the wuick menu which is the one on top with the little Save, Undo and Redu icons.

Once you open/create a DB, you can then customize the ribbon to your liking.

Cheers.
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 34916248
AFAIK, there is no option available for that. However, you can play around with some XML and VBA coding to achieve what you want.

The link below would be a good start:

http://msdn.microsoft.com/en-us/library/bb425845(v=office.12).aspx

Sincerely,
Ed
0
 
LVL 1

Author Comment

by:stephenlecomptejr
ID: 34916874
The reason why I was believing there is a way is because Adobe PDF comes up initially.
I guess that's an add-in as this describes:
http://msdn.microsoft.com/en-us/library/aa902693(v=office.12).aspx

0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 1

Author Comment

by:stephenlecomptejr
ID: 34916958
What I am trying to do is have a ribbon button where I click on it and it opens another database.  I have all the VBA coding to do this but I guess with the above URL I've got to create a Visual Studio add-in - which I have the capability to do.  Then just use vb.net to open the other database.

I'll try it - but I don't want to waste my time developing it if it won't come up at the start of the Access applciation and instead only appear at the opening of an Access database.
0
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 2000 total points
ID: 34966778
hi Stephen,
See   http://msdn.microsoft.com/en-us/library/aa338202(v=office.12).aspx#OfficeCustomizingRibbonUIforDevelopers_AppLevel

Why can't you prompt (via a listbox) the user to select the path (open/create) to take, and then load dynamic ribbon customizations when you open a database?

When customizing the Access UI, you have two choices: You can store your customizations in a special table and have Access automatically load the markup for you, or you can store the customizations in a location of your choosing and load the markup manually by calling the Application.LoadCustomUI method.

Customizations that you load by using the LoadCustomUI method are available only while the database is open. You need to call LoadCustomUI each time you open the database. This technique is useful for applications that need to assign custom UI programmatically at run time.
0
 
LVL 1

Author Closing Comment

by:stephenlecomptejr
ID: 34966918
Thank you very much.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 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