Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007

    Question Unanswered: Creating Sub-Sub-Menu of Ms Access


    Im stuck on this, Hope somebody can help me with this one.

    How can I make a sub-sub menu in MS Access?

    I have "MAIN MENU" and under it is the submenu "My Menu" then under it is "Own Menu".
    How can I do to make a sub-sub-sub menu Menu that if i click/position the mouse on submenu " My Menu there will be another sub menu that will pop up

    a picture of I want to have:

    Gen Menu
    --My Menu
    ----Own Menu
    ------sub sub sub menu

    Here is a portion of my code after I created then MainMenu "Gen Menu"

    Set a = MainMenu.Controls.Add(Type:=msoControlPopup, Before:=1)
    cbPopup.Caption = "My Menu"

    Set cbButton = cbPopup.Controls.Add(Type:=msoControlButton, Before:=1)
    With cbButton
    .Caption = "Own Menu"
    .Enabled = True
    End With

    End Function

    How can I create another submenu under the "own Menu"

  2. #2
    Join Date
    Mar 2005
    Phoenix AZ
    I will probably get ripped on here for saying this, but I know you can go at least three levels deep if you use macros for your menus. Other than AutoExec, those are pretty much the only macros I use. I get new requests for reports all of the time, and at least to me, it is quicker for me to just add or delete a row in a macro than to do it in code.

Posting Permissions

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