Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69

    Unanswered: Hide default menubar

    How do I turn off or hide the default built-in menubar(file, edit, insert, records, etc.) in Access 97?

    Thanks.
    "Doing stuff is overrated. Take Hitler for example. He did lots but don't we all wish he'd have just stayed home and gotten stoned?"

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    tools... startup...

  3. #3
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69
    I've done that but the built-in menubar still comes up.
    "Doing stuff is overrated. Take Hitler for example. He did lots but don't we all wish he'd have just stayed home and gotten stoned?"

  4. #4
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    only a small menubar should show. file.. and two other options. You can't even print when you minimize this toolbar.
    So if you want it to disappear completely, then I can't help you, sorry..

  5. #5
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69
    Thanks for your help. I appreciate it.

    I do need it to disappear completely though. We have a couple of other A97 apps that have no menubars at all. I've tried duplicating those but I'm missing something.
    "Doing stuff is overrated. Take Hitler for example. He did lots but don't we all wish he'd have just stayed home and gotten stoned?"

  6. #6
    Join Date
    Nov 2001
    Posts
    336
    Here is some code I wrote to turn toolbars off:


    Private oCol As Collection

    Dim tlb As CommandBar

    For Each tlb In CommandBars
    If tlb.Visible Then
    If tlb.Type = msoBarTypeNormal Then
    oCol.Add tlb.Name
    tlb.Visible = False
    End If
    End If
    Next
    Set tlb = Nothing

    I keep the list of turned off toolbars in oCol just in case I'll need to turn on them back.


    Private Sub Form_Close()
    Set oCol = Nothing
    End Sub

    Private Sub Form_Load()
    Set oCol = New Collection
    End Sub

    Igor

  7. #7
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69
    Outstanding. Thanks a bunch.
    "Doing stuff is overrated. Take Hitler for example. He did lots but don't we all wish he'd have just stayed home and gotten stoned?"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •