DoCmd.ShowToolbar
(1)
Access 2007
(1)
Access 2003
(1)
PleaseNOOSpamKallal
(1)
Database
(1)
AcToolbarNo
(1)
Edmonton
(1)
Kallal
(1)
Turning off Ribbons in Access 2007
Asked By Pete_E
20-Nov-09 10:31 AM
I recently moved a rather large application from Access 2003 to Access 2007.
I have user specific custom menus and toolbars in the database and need to
shut off the 2007 ribbons as they are not needed. Is there an efficient way
to do this through a startup macro or short snippit of startup code?
--
Pete E
Assuming you have converted the db to A2007, as far as I know, you must haveat
Jeanette Cunningham replied to Pete_E
20-Nov-09 08:06 PM
Assuming you have converted the db to A2007, as far as I know, you must have
at least one ribbon.
You could build a custom ribbon with only one group/button on it, and show
that, and also minimize it so that it does not take up much space.
I am assuming that there is code to minimize the ribbon - as I have never
needed to do this in code.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
The following will hide the office button,t he QAT, and also hide theribbon....
Albert D. Kallal replied to Pete_E
20-Nov-09 10:39 PM
The following will hide the office button,t he QAT, and also hide the
ribbon.....
DoCmd.ShowToolbar "Ribbon", acToolbarNo
If you leave your app in 2003 format, then your startup code and custom
menus should show, and the ribbon should no display anyway.
Just make sure you un-check in startup the allow built in tool bars.
This is outlined here:
http://www.accessribbon.de/en/index.php?FAQ:7
so, you have several approaches here that should work...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
Thanks Tony, has this always been possible in A2007?
Jeanette Cunningham replied to Albert D. Kallal
21-Nov-09 01:50 AM
Thanks Tony, has this always been possible in A2007?
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
You mean:DoCmd.
Albert D. Kallal replied to Jeanette Cunningham
23-Nov-09 04:17 AM
You mean:
DoCmd.ShowToolbar "Ribbon", acToolbarNo
Yes, it is a one line command that hides all of the ribbon, the office
buttion and even the QAT.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
DataBase Turning off Ribbons in Access 2007 I recently moved a rather large application from Access 2003 to Access 2007. I have user specific custom menus and toolbars in the database and need to shut off the 2007 ribbons as they are not needed. Is there an efficient never needed to do this in code. Jeanette Cunningham MS Access MVP - - Melbourne Victoria Australia The following will hide the office button, t he QAT, and also hide the ribbon. . . . . DoCmd ShowToolbar "Ribbon", acToolbarNo If you leave your app in 2003 format
DataBase Access 2007 Runtime Hallo Leute, in der Firma habe ich Access 2003 und alle anderen Arbeitsplätze greifen auf die DB über die Runtime Access 2000 zu. Jetzt gibt es ja die Runtime für Access 2007 zur freien Verwendung. Hier nun meine Frage. Kann ich auf einen Microsoft-Lizenzberater! Gruss - Mark - - Informationen fuer Neulinge in den Access-Newsgroups unter http: / / www.doerbandt.de / Access / Newbie.htm Bitte keine eMails auf Newsgroup-Beiträge senden. Hallo denn EULA-mäßig bedenklich sein? - - Servus Karl * ** ** ** ** Ich beantworte keine Access-Fragen per Email. * ** ** ** ** Access-FAQ: http: / / www.donkarl.com Access
DataBase Access 2007 Hello! Can anyone help me please . . . how do I turn off Access 2007's ribbon when I open an Access 2000 dB application? Thanks in anticipation. You mean you would instead of the ribbon? Sorry, you cannot. - - Doug Steele, Microsoft Access MVP http: / / I.Am / DougSteele (no e-mails, please!) I No . . . sorry . . . I am looking for code to do it . . . DoCmd.ShowToolbar "Ribbon", acToolbarNo completely hides the ribbon. But if this is in your form and report properties. You can also make Access run with your custom Access 2003-style menus and toolbars and no ribbon, by setting
customized ribbon not associated with a form I have an Access 2003 application that we are converting to Access 2007. I have (finally) figured out how to create customized ribbons The code that loads the Query Design form in the Access 2003 version is: DoCmd.OpenQuery strQueryFullName, acViewDesign, acEdit DoCmd.RunCommand acCmdDesignView DoCmd.ShowToolbar "CLS Query Design", acToolbarYes I have read through a lot
Display custom Ribbon / Toolbar in Query Design We have an Access 2003 application that we are converting to Access 2007. I have (finally) figured out how to create customized ribbons the Query Design form and a custom Toolbar in the Access 2003 version is: DoCmd.OpenQuery strQueryFullName, acViewDesign, acEdit DoCmd.RunCommand acCmdDesignView DoCmd.ShowToolbar "CLS Query Design", acToolbarYes I have tried replacing the name
DataBase Code that worked in 2003 doesn't work in 2007 I have been using the code below in a bunch quite some time. It prevents the user from closing the Access program (Access 2003 and older) using the application close button. It works great control on my form. However, it does not work in Access 2007. Can anyone suggest why? Any way that you can see Long Public Sub FMS_AppCloseEnabled(pfEnabled As Boolean) ' Comments: Control the Access close button. ' Disabling it forces the user to exit within is does any code run? Code does not run in 2007 unless your database resides in a folder that has been location. To trust your folder, click: Office Button (top left) Access Options (bottom of dialog) Trust Center (left) Trust Center Settings
DataBase Vista Preliminar Access 2007 Hola amgi@s, Necesito de su valiosa ayuda con lo informe se presente en el Ribbon una cinta predeterminada de Access de nombre "Vista Preliminar", en otras aplicaciones que he desarrollado el siguiente comando en el evento al abrir el informe: DoCmd.ShowToolbar "Vista Preliminar", acToolbarYes Pero no me funciona, pues esta linea de c??digo lo encontr?? para Access 2003, no se si ha cambiado en 2007. Anexo V??deo: Video http: / / www.4shared.com / file / 133257080 te podr??a servir. - - Saludos Jos?? Bengoechea Ibaceta [MS-MVP Access] http: / / jbengoechea.com / http: / / jbchea.net http: / / geeks.ms / blogs / access _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature
DataBase Desactivar todos los menus de access Existe la posiblidad de desaparecer la barra de herramients de access, lo que busco es tratar de que mi aplicacion de este no me deja. Podrain ayudarme con esto - - mao En access 2007 no lo he probado, pero verifica en "opciones de access", "opciones de barra de herramientas y cinta de opciones" y creado, asi como desactiva las opciones que no desees. En 2003 lo lograbas en: "herramientas" , "inicio". Espero le sea de ayuda que se abre de la aplicaci??n desactiva el Ribbon: DoCmd.ShowToolbar "Ribbon", acToolbarNo - - Un saludo Xavi http: / / www.llodax.com http: / / www.mvp-access.com / foro noticias:CB5731FF-67E0-49CC-93E6-E82DFC8655D2@microsoft.com se ejecute sin tener en el fondo la ventana de access maximizada? - - mao Gracias xavi es perfecto. Una pregunta mas hay