By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

Minimize Access 2007 Ribbon

P: n/a
Hi Everybody

I have a 2003 application that I am trying to run under 2007, The code
seems to work OK but the Ribbon is a big problem. It just takes up too
much space away from the application.

Does anyone know a quick and easy way to code a 'minimize' of the
Access 2007 Ribbon when the application starts so that the user cannot
restore the Ribbon or use any part of it?

I would have prefered the Ribbon to be made invisible, but I read that
this is impossible. Is this true?

Thanks

Den

Jul 31 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
de*******@yahoo.co.uk wrote:
Hi Everybody

I have a 2003 application that I am trying to run under 2007, The code
seems to work OK but the Ribbon is a big problem. It just takes up too
much space away from the application.

Does anyone know a quick and easy way to code a 'minimize' of the
Access 2007 Ribbon when the application starts so that the user cannot
restore the Ribbon or use any part of it?

I would have prefered the Ribbon to be made invisible, but I read that
this is impossible. Is this true?

Thanks

Den
I have a Table: ID, RibbonName, RibbonXML
The values for record one are:
1
***
HideRibbon
***
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>
***

I have a public function

Public Function temp()
Dim r As DAO.Recordset
Set r = DBEngine(0)(0).OpenRecordset("Table1")
Application.LoadCustomUI r.Collect(1), r.Collect(2)
Set r = Nothing
End Function

I run the public function from the/a AutoExec macro.
Action: RunCode
Argument: temp()

This hides the ribbon.

Tonight I tested it by double clicking a 2007 database in explorer. The
autoexec macro did not seem to fire. If I doubleclick on AutoExec then
the ribbon disappears. Arggggggghhhh. I guess this requires more work.
Of course, not running the AutoExec macro when double clicking from
explorer may be a Beta Bug.

It seems to me this used to work; it works now if one opens Access 2007
and then opens the db.

It is something for me to work on and may be a bit of a guide for you.

Aug 1 '06 #2

P: n/a
Thanks very much Lyle. Even your imperfect code has helped me
enormously. I have a few ideas which may circumvent the possible 'Beta
bug'. I will try them out sometime today (or tonight) and report back.

Den

Lyle Fairfield wrote:
de*******@yahoo.co.uk wrote:
Hi Everybody

I have a 2003 application that I am trying to run under 2007, The code
seems to work OK but the Ribbon is a big problem. It just takes up too
much space away from the application.

Does anyone know a quick and easy way to code a 'minimize' of the
Access 2007 Ribbon when the application starts so that the user cannot
restore the Ribbon or use any part of it?

I would have prefered the Ribbon to be made invisible, but I read that
this is impossible. Is this true?

Thanks

Den

I have a Table: ID, RibbonName, RibbonXML
The values for record one are:
1
***
HideRibbon
***
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>
***

I have a public function

Public Function temp()
Dim r As DAO.Recordset
Set r = DBEngine(0)(0).OpenRecordset("Table1")
Application.LoadCustomUI r.Collect(1), r.Collect(2)
Set r = Nothing
End Function

I run the public function from the/a AutoExec macro.
Action: RunCode
Argument: temp()

This hides the ribbon.

Tonight I tested it by double clicking a 2007 database in explorer. The
autoexec macro did not seem to fire. If I doubleclick on AutoExec then
the ribbon disappears. Arggggggghhhh. I guess this requires more work.
Of course, not running the AutoExec macro when double clicking from
explorer may be a Beta Bug.

It seems to me this used to work; it works now if one opens Access 2007
and then opens the db.

It is something for me to work on and may be a bit of a guide for you.
Aug 1 '06 #3

P: n/a
Caution, Lyle! Defeating the ribbon may bring retaliation from the Boys and
Girls in Redmond. According to them, if it's not the greatest invention
since sex, it's at least the greatest since sliced bread.

Larry
"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
de*******@yahoo.co.uk wrote:
>Hi Everybody

I have a 2003 application that I am trying to run under 2007, The code
seems to work OK but the Ribbon is a big problem. It just takes up too
much space away from the application.

Does anyone know a quick and easy way to code a 'minimize' of the
Access 2007 Ribbon when the application starts so that the user cannot
restore the Ribbon or use any part of it?

I would have prefered the Ribbon to be made invisible, but I read that
this is impossible. Is this true?

Thanks

Den

I have a Table: ID, RibbonName, RibbonXML
The values for record one are:
1
***
HideRibbon
***
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>
***

I have a public function

Public Function temp()
Dim r As DAO.Recordset
Set r = DBEngine(0)(0).OpenRecordset("Table1")
Application.LoadCustomUI r.Collect(1), r.Collect(2)
Set r = Nothing
End Function

I run the public function from the/a AutoExec macro.
Action: RunCode
Argument: temp()

This hides the ribbon.

Tonight I tested it by double clicking a 2007 database in explorer. The
autoexec macro did not seem to fire. If I doubleclick on AutoExec then
the ribbon disappears. Arggggggghhhh. I guess this requires more work.
Of course, not running the AutoExec macro when double clicking from
explorer may be a Beta Bug.

It seems to me this used to work; it works now if one opens Access 2007
and then opens the db.

It is something for me to work on and may be a bit of a guide for you.

Aug 1 '06 #4

P: n/a
Larry Linson wrote:
Caution, Lyle! Defeating the ribbon may bring retaliation from the Boys and
Girls in Redmond. According to them, if it's not the greatest invention
since sex, it's at least the greatest since sliced bread.
I think the quote is, "Greater than somethin' munchy".

Aug 1 '06 #5

P: n/a
Lyle, even after some experimentation, I could not get your method to
work. (But Ctrl-F1 still worked - so the Ribbon was not frozen.)

I should point out that I cannot double-click an MDB or MDE because I
have to go through a Shortcut due to MS security.

I have discovered some alternative code that I will be trying out in
the next few days.

In the meantime, if anyone has a fully working solution then please let
us know.

Den

Lyle Fairfield wrote:
de*******@yahoo.co.uk wrote:
Hi Everybody

I have a 2003 application that I am trying to run under 2007, The code
seems to work OK but the Ribbon is a big problem. It just takes up too
much space away from the application.

Does anyone know a quick and easy way to code a 'minimize' of the
Access 2007 Ribbon when the application starts so that the user cannot
restore the Ribbon or use any part of it?

I would have prefered the Ribbon to be made invisible, but I read that
this is impossible. Is this true?

Thanks

Den

I have a Table: ID, RibbonName, RibbonXML
The values for record one are:
1
***
HideRibbon
***
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>
***

I have a public function

Public Function temp()
Dim r As DAO.Recordset
Set r = DBEngine(0)(0).OpenRecordset("Table1")
Application.LoadCustomUI r.Collect(1), r.Collect(2)
Set r = Nothing
End Function

I run the public function from the/a AutoExec macro.
Action: RunCode
Argument: temp()

This hides the ribbon.

Tonight I tested it by double clicking a 2007 database in explorer. The
autoexec macro did not seem to fire. If I doubleclick on AutoExec then
the ribbon disappears. Arggggggghhhh. I guess this requires more work.
Of course, not running the AutoExec macro when double clicking from
explorer may be a Beta Bug.

It seems to me this used to work; it works now if one opens Access 2007
and then opens the db.

It is something for me to work on and may be a bit of a guide for you.
Aug 1 '06 #6

P: n/a
de*******@yahoo.co.uk wrote:
Lyle, even after some experimentation, I could not get your method to
work. (But Ctrl-F1 still worked - so the Ribbon was not frozen.)
Perhaps, you'd like to download and extract the file where it works and
report what happens?

http://www.ffdba.com/downloads/database1.zip

Aug 1 '06 #7

P: n/a
Lyle, unfortunately, your download zip file was not practical for me
because I wanted to keep my 2003 MDB with the minimum of 2007 changes
and not yet go fully over to 2007.

In addition, my database has to work from a Shortcut as I use Microsoft
Security.

In addition, my database is split over a network.

However, I have managed to successfully implement my database in Access
2007 with no Ribbon.

What I did was follow the instructions issued by Microsoft at:

http://msdn2.microsoft.com/en-us/library/ms406046.aspx

(Scroll down to: 'Creating an Access Application-Level Custom Ribbon')

But, I could not make the changes listed in the MSDN steps 1 and 2 as I
could not find the View tab. (Has anyone found this in the Beta 2?)

My RibbonXML memo field was changed to:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>

In fact, the Microsoft technique is very similar to yours - apart from
adding the new Ribbon ID to the Application Options (steps 19-22). I
recommend checking that the Display (aka Startup) Form name is still
displayed in the Application Options when the Ribbon ID is added to the
Toolbar Options. Access had removed my Startup form when I did the
final application restart step.

What I have since learnt is that hiding the ribbon is best done as part
of the final Application Options changes prior to creating an MDE.

Anyway, Lyle, thanks very much for your help.

Den

Lyle Fairfield wrote:
de*******@yahoo.co.uk wrote:
Lyle, even after some experimentation, I could not get your method to
work. (But Ctrl-F1 still worked - so the Ribbon was not frozen.)

Perhaps, you'd like to download and extract the file where it works and
report what happens?

http://www.ffdba.com/downloads/database1.zip
Aug 3 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.