Hello Everyone,

I am having a little issue and I am not sure how to solve it. I designed my own custom ribbon on a database using Microsoft Access 2007. I would like to save my database as an accde file. How can I accomplish this since I no longer have the default ribbon. Is there a vba code I can use?

Hi

I'm no expert on the infamous Ribbon, but how/where are you storing the XML for your ribbon ?

If you have a USysRibbon table and store both the XML and the ribbon name in that table, you should be just able to set the default ribbon to the name of your custom ribbon (in Access Options-->Current Database-->Ribbon Name) and then compile your project into an accde file, which **should** then use the ribbon you created.

That's the method I normally use for custom ribbons, not that I often create them!!

One of the best sites I know for 'all things Ribbon' is AccessRibbon which should give you all the info you need

I have looked into AccessRibbon...thankl you very much for the suggestion. What you mentioned is absolutely right. My problem is the home tab from the default Microsoft Access ribbon is showing along with my customized ribbon, even though all the buttons from the Microsoft Access default home tab is deactivated. Do you know how I can get rid of this.

Hi

You should be able to edit the XML of your custom ribbon and remove the Home Tab.

You could look at the XML in a text editor. Notepad is OK, but I wouldn't recommend using Word if you're planning on saving any edits you make - Word has a habit of 'adding things' that you probably don't want!!

Thanks Alan again for all your help. I figured it out.

(IMG:style_emoticons/default/yw.gif) - glad you got it working

>> You could look at the XML in a text editor. <<

I would recommend using XML Notepad or Visual Studio Express (or the full version of Visual Studio).

Of course, during development, you will hold down the shift key so your startup settings don't run. You then develop for a while, and then to test in "user" mode, you exit..and then re-enter the application without the shift key bypassed. You will likely do this dance all day long as you run/test as user mode, and then flip back in to developer mode (shift key used..so you
don't get the main custom menu). So, you can't develop, or really modify things when you run your application with the startup settings...so you must shift-by-pass them when you want to work.

I used to use alt f4 key to exit and then in most cases the mdb (now accdB) file should still be highlighted in the windows explore a quick jab at the enter key (and, hold down shift key if you need be).

This key stroke sequence and exiting and re-entering the application will occur CONSTANTLY all day long when you are developing.

In fact to save the exit + reenter, I have a compact + repair on the QAT. So is now one click on that button to "test" the application.

So, if you have a custom ribbon as you have, then all bets for ANY kind of development is off unless you hold down the shift key to get into "developer" mode with the standard ribbons.

When you happy with the results, then you as a general rule compile into an accDE and distribute that to your users.

So for ANY application with startup forms, startup ribbons and custom menu bars or now ribbons, the standard practice for 15+ years is you have to hold down the shift key to disable that truckload of user options so you can work as a developer on the application.

So if the basic Access ribbons and UI are not showing then hold down the shift key during startup to disable all of those startup options, and this shift key also applies to custom ribbons settings you have.

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
kallal@msn.com

Hi

I acquired a program, done in Access, to create my ribbons. This program allows me to view the ribbon in real time. I thought that was amazing! I even came to like to ride the ribbons, which I hated.

See the image of the program. You change the XML and display the ribbon in real time.

http://www.ribbon01.com/



This post has been edited by Sampaio: Apr 18 2012, 03:44 AM

Thanks everyone for your help. I really appreciate this. You guys are awesome!