Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

How to adjust the default ribbon for Microsoft Access 2007?

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
stephenlecomptejr
Asked:
stephenlecomptejr
1 Solution
 
Cesar AracenaPHP EnthusiastCommented:
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
 
MINDSUPERBCommented:
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
 
stephenlecomptejrAuthor Commented:
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
stephenlecomptejrAuthor Commented:
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
 
puppydogbuddyCommented:
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
 
stephenlecomptejrAuthor Commented:
Thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now