473,698 Members | 2,213 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Minimize Access 2007 Ribbon

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
7 11422
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.microso ft.com/office/2006/01/customui">
<ribbon startFromScratc h="true">
</ribbon>
</customUI>
***

I have a public function

Public Function temp()
Dim r As DAO.Recordset
Set r = DBEngine(0)(0). OpenRecordset(" Table1")
Application.Loa dCustomUI 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
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.microso ft.com/office/2006/01/customui">
<ribbon startFromScratc h="true">
</ribbon>
</customUI>
***

I have a public function

Public Function temp()
Dim r As DAO.Recordset
Set r = DBEngine(0)(0). OpenRecordset(" Table1")
Application.Loa dCustomUI 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
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.goo glegroups.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.microso ft.com/office/2006/01/customui">
<ribbon startFromScratc h="true">
</ribbon>
</customUI>
***

I have a public function

Public Function temp()
Dim r As DAO.Recordset
Set r = DBEngine(0)(0). OpenRecordset(" Table1")
Application.Loa dCustomUI 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
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
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.microso ft.com/office/2006/01/customui">
<ribbon startFromScratc h="true">
</ribbon>
</customUI>
***

I have a public function

Public Function temp()
Dim r As DAO.Recordset
Set r = DBEngine(0)(0). OpenRecordset(" Table1")
Application.Loa dCustomUI 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
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
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.microso ft.com/office/2006/01/customui">
<ribbon startFromScratc h="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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

37
5228
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why would you even continue to use Access as a backend when you have a much superior option in SQL express? What about as a future front-end development tool? Let's get serious. Microsoft continues to publish numerous articles and videos on how you...
27
45553
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same height as they were in previous versions or will they be the "ribbon" style that takes up a huge portion of the screen? Also when I use Access 2007 to open an Access 2003 database that has custom menu bars they display as they did in Access...
6
2211
by: ARC | last post by:
Ok, so I'm looking at Access 2007, and I have imported my existing Access 97 application. I'm feeling a bit overwelmed in what to do here. In my original 97 application, I had one form: Mainmenu, which contained a header area / customer selection area, and a subform. I had a custom toolbar that had a button for each major screen. So clicking Customers would load the customers form into the subform of the mainmenu. By choosing a customer in...
0
3896
by: Bertha94 | last post by:
I am trying to figure out how to minimize the ribbon when the program starts up. From what i've read, the only way Excel can recognize is by the height of the command bar. I have a rough sketch of code that has been discussed, but none have verified one working. If Application.CommandBars.Item("Ribbon").Height = 150 Then Application.ActiveWindow.ToggleRibbon() Else 'Whatever you need to do when minimized
1
4444
by: Bob Alston | last post by:
Trying to install some software on Access 2007. The software works just fine on earlier versions of Access. I have been told that it works on Access 2007 but I have not seen that personally. The command buttons on my user-created forms do not function when it is run under Access 2007. The operating system is Windows XP home SP2.
2
2286
by: D Hammer - Sayner | last post by:
I am new to using Access 2007 and a novice with Access period. I have two older databases that I created in Access 2000. When I open DB1 I get the usual ribbon menus shown. When I open DB2 however, the only ribbon showing is the Home Ribbon and when I click on the Microsoft Office Button, the only thing showing under it is Close Database and Exit Access. What do I need to do to get all of the command buttons back in the Ribbon Menus...
4
4288
by: Bob | last post by:
Hi, Can it's possible to use a customized QAT in Access 2007 with a Ribbon using "USysRibbons" ? because in Access options i can't select 2 ribbon name. Thank's
9
4491
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd like to know is the stability, speed & ease of use of both the products. I believe Access 2007 has a new file format too and that it may be slower.
10
2809
by: prakashwadhwani | last post by:
Office 2007 & thus Access has had it's menus replaced with the Ribbon Bar. It's very disconcerting. In Word, Excel, Access, I feel totally lost. Also all the shortcut Menu pulldowns don't work anymore ... eg Alt F-S to save a file Alt F-U for Page Setup in Word/Excel etc. etc.
0
8601
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9156
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9021
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8892
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7716
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6518
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4365
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4614
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
1998
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.