asked on

Access 2010 ribbon

I have a database that has been built in Access 2003. I tried to port it to 2007, but found that the Ribbon took up too much screen space and I only need a thin bar of icons going across the top of the form. I have heard that 2010 allows you to change the height of the ribbon. Is this correct?

Thanks for your help.

Adam Menkes

You could also remove the ribbon if you don't want it.
DoCmd.ShowToolbar "Ribbon", acToolbarNo

Andy Brown

ASKER

I could, but I need the icons and it never looks as good when you try and fudge it with buttons.

Adam Menkes

What I do is this (which also disables the holding of the shift key to get to your tables/code/etc):

If IsRunTime() Then
DoCmd.ShowToolbar "Ribbon", acToolbarNo
result = CurrentDb.CreateProperty("AllowBypassKey", DB_BOOLEAN, False)
End If

Adam Menkes

I do the above, and then create my own ribbon. I will post an example shortly.

Andy Brown

ASKER

Thanks for your help - much appreciated.

Can you adjust the height of the ribbon, which I think is key for this app.

Adam Menkes

I have not done it, but it appears possible, based on this link: http://www.aspfree.com/c/a/.NET/The-Windows-Ribbon-Framework/2/

You may have to find the window handle and do some Windows API calls, unless someone has a simpler solution.

Andy Brown

ASKER

Why is nothing ever straightforward......:O).

I'll do a bit of routing around and come back if I find/get the fix.

Thanks for your help once again.

Andy Brown

ASKER

I've had a quick look and so far haven't found anything I can use. One chap claims that not using the Ribbon in its intended format is old fashioned and I do understand where he is comming from. However, this application has a total of 20 icons (with captions) that is all the user needs to see - So the Ribbon height is overkill.

I don't want the user to have to minimise / grow the ribbon as it is inefficient for this type of app.

Rant over.....

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andy Brown

ASKER

I don't get irritated by too much - but this one.......and it's not as if nobody has mentioned it on the bloggs / focus groups.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

I am spending soooooooo much time just looking for stuff in A2010 it's insane. A total waste of my time.

mx

SOLUTION

Adam Menkes

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andy Brown

ASKER

I see everyones point of view, and agree from a users point-of-view the Ribbon is just fine. But for this database it's just too much as I couldn't think of enough things to fill it with. For me, it would have been perfect if I could have reduced the height - just a little.

Thanks everyone for your help on this one.

4ward

This does not work in 2010

Andy Brown

ASKER

Thanks for the info.

I'm starting to think about porting the front-end over to .Net (a job I am not looking forward to). But at least this way, I'll have much more control over everything like that.