Re: Hide Ribbon in Access 2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Have a look at my post and thread (dated 02/09/08) in
microsoft.public.access.commandbarsui for a possible answer to your problem.
You may need to do version checking regarding Access 2k3 or 2k7.
Regards

"sherwinb" <sherwinb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3AEC24B8-D3FC-406A-A4F8-0F7BED98B753@xxxxxxxxxxxxxxxx
Hi,

I used the following code successfully in Access 2003 to hide the menu bar
on a form's OnLoad property:

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

What code should I use to hide the ribbon in Access 2007 and can I combine
the code so that the ribbon or menu bar is hidden depending on if the user
has Access 2003 or 2007?

Thanks


.

Relevant Pages

  • RE: Command Bar
    ... I want to set the menu bar at the top of the screen by following ... Dim nHeight, nSX, nSY As Long ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.access.modulesdaovba)
  • API Status Bar - Mike?
    ... then it draws a status bar using API. ... Dim bRedrawFlag As Boolean ... 'Divide up screen width to use for panel spacing after converting to ... SendMessage hWndStatus, SB_SETPARTS, nParts, wParts ...
    (comp.lang.basic.visual.misc)
  • Re: Menus
    ... I send this tip to TK to only have certain options enabled in the worksheet menu bar ... Run the second sub to enabled everything ... Dim IDnum As Variant ... Dim ctrl_1 As CommandBarControl ...
    (microsoft.public.excel.programming)
  • RE: Goal Seek Advice
    ... Dim rngResult As Range ... Dim RangeCountTimeBasisMin As String ... Application.StatusBar = False 'Return control of the status bar to Excel ... Dim dValue1 As Double, dValue2 As Double, dValue3 As Double ...
    (microsoft.public.excel.programming)
  • Re: Screen view 100%
    ... Ctrl+F1 hides the ribbon. ... stuff at the top, a total of maybe 40 pixels, plus the status bar at ... Word FAQ: http://mvps.org/word ... MVP FAQ site: http://mvps.org/ ...
    (microsoft.public.word.newusers)