Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to adjust the default ribbon for Microsoft Access 2007?

Posted on 2011-02-17
7
Medium Priority
?
364 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

604 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