Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating popup shortcut menu (Access 2007)

    Hi everyone...
    I'm making progress. I just finished my first Custom UI in xml, and have learned how to hide all ribbon tabs except my newly created custom tab. I have also learned more about hiding the Navigation bar from users, successfully created my own Main switchboard, complete with passwords for users to move further into the database, put it in startup and removed all options for closing it except for a 'close database' button on it's face. I still have to work with the admin command and the BypassStartupKey code, (admin command allowing designers to enter password to get by BypassStartupKey options at design time, and then entering again before leaving design)...
    shewwww....
    but right now I am sitting on this popup shortcut menu. You know, when a user right-clicks on an open form, table or report ect...I would like to remove a few of the commands from this, so want to create my own popup shortcut menu. There is a place to put it in startup in the customize dialog, but creating one is not like Access 2003. I am assuming I am going to need some xml example code to get me started, like I did with my new CustomUI ribbon code. I found a great example online to get me started there, however, I have not found any to help me get started created the shortcut popup menu when someone right clicks. I'm wondering if anyone can point me in the right direction. I haven't found anything on Microsoft's website (with examples). I thought of putting an "s" in front of the "xmlns" part of the statement, but then I won't be using the tab command on a popup menu, so still left me baffled.

    Thanks for any help locating some examples on this.

    Posting the example code I used for the custom ribbon (must be placed in a table called USysRibbons) for anyone that might need it:

    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    <ribbon>
    <tabs>
    <tab id="XXX" label="XXX">
    <group id="XXX" label="XXX">
    <button id="XXX" label="XXX" />
    </group>
    </tab>
    </tabs>
    </ribbon>
    </customUI>

    So a piece of my code (I've added a lot in between) would be:

    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">

    <ribbon startFromScratch="false">
    <tabs>

    <tab id="dbCustomTab" label="My Controls" visible="true">

    <group id="dbCustomGroup" label="Management">
    <control idMso="FileSave" label="Save" enabled="true"/>
    <control idMso="FileCloseDatabase" label="Close Database" enabled="true"/>
    </group>
    </tab>
    </tabs>
    </ribbon>
    </customUI>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Creating popup shortcut menu (Access 2007)

    Sorry about the lack of replies. I fear that the majority of the Loungers who regularly post replies here aren't using Office 2007 yet...

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating popup shortcut menu (Access 2007)

    Hans,

    Nor' do I wish to be. But I've been slam-dunked into 2007 (still teaching 2003 90% of time), but preparing classes for 2007 and teaching a few here and there. I feel like a babe in the woods with Advanced Access 2007 security, as I had it down cold in 2003...Access 2007 is pain-stakingly more difficult to adjust too, and though I understand what changes I am going to have to make, getting the help to guide me has been hard. I totally understand anyone's reluctance to answer the 2007 questions I'm tossing out here, but I have to try. I have no one else to rely on.

    Thanks for the feedback...maybe someone, somewhere will bite at this question and guide me to a site that has "how-to's" on making a new shortcut popup menu in Access 2007.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Creating popup shortcut menu (Access 2007)

    I have been looking for some information on this topic, with very little success.

    Here is an article with some code for customizing existing shortcut menus in Word.

    Here is a blog post that explains the official MS point of view on customization in Office 2007. I take it to say that in Access the options available are the Quick Access toolbar, and creating Custom ribbons.
    Regards
    John



  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating popup shortcut menu (Access 2007)

    John,
    Thanks for the links. I looked at them yet no one still discusses creating a 2007 shortcut popup menu from scratch, like we did in Access 2003. What bothers me is there must be a way...as in Access's customization there is a dropdown box to add one. Right beside the dropdown to add my brand new UI xml written ribbon. If it has a choice that allows me to set my custom ribbon as the default, (and it works)...why then offer me a dropdown to set a custom shortcut menu (popup) beside it if there is no way to make one? I don't want the QAT, and I don't want to customize the existing one. I want to add and remove icons to the shortcut menu via my descretion like we used too. All the code in your links seem to be VBA, not xml...if you see any xml code for shortcut menus, hollar', I sure would appreciate the news. I had to create the custom ribbon in xml, and I am assuming I will have to create the shortcut menu in xml as well...just a guess.
    Thanks for the feedback
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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