Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Location
    Fort Knox
    Posts
    32

    Unanswered: Shortcut Menus - how far does it go? [EDITED]

    EDIT: Sorry for the previous long post, I did some testing and I'm finally able to narrow down my question.

    Ok, in..

    Office Menu > Access Options > Current Database

    ... I have most of the options that give access to the default GUI un-checked, like "Default Shortcut Menus", etc. I messed around with making menus using macros, and assigning a global shortcut menu. I'm trying to invoke the Expression Builder in Query Design mode with "Default Shortcut Menus" disabled in Access Options. Here's what I did first:

    http://photoserver.ws/images/bUKb4cdfe7ced175c.png

    That basically only caused a shortcut menu to appear when I right click anywhere EXCEPT in query design mode. So I tried a silly work around:

    http://photoserver.ws/images/iysJ4cdfe48bb1218.png

    This actually worked, since when a query is opened, it automatically selects the name of the first field, which is a suitable situation for the Builder to be invoked. But of course I can't invoke the builder in any field with this method, nor can I invoke the builder to create complex criteria for other fields.

    So I tried yet another workaround. I tried to find the Builder in the ControlID list for Office and add it to the Quick Access Toolbar.

    Link: Download details: 2007 Office System Document: Lists of Control IDs

    But it is nowhere to be found. However I can add it to the Quick Access Toolbar manually, but I can't design the database to have it there. Here is my current Ribbon XML for my database:

    Code:
    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
      <ribbon startFromScratch="true">
        <qat>
          <documentControls>
            <button idMso="FileSave" />
            <button idMso="PrintDialogAccess" />
            <button idMso="PublishToPdfOrEdoc" />
            <button idMso="ExportExcel" />
            <button idMso="PrintPreviewClose" />
            <button idMso="Builder" />
          </documentControls>
        </qat>
        <officeMenu>
          <control idMso="FileNewDatabase" visible="false" />
          <control idMso="FileOpenDatabase" visible="false" />
          <control idMso="FileCloseDatabase" visible="false" />
        </officeMenu>
      </ribbon>
    </customUI>
    As you can see I tried to guess what the idMso would be for the builder. I also tried "InvokeBuilder" (like the RunCommand option) but nothing.

    The ultimate goal here is to allow users to make their own queries, and to allow me to make queries as the database is being used, without having to lock everyone out while I'm in design mode. So I'll need to also invoke the "Show Tables" window too. I think I could figure that one out, I'll just open it every tiime the user "edits" a query. (I have an "edit query" button that opens a selected query in design mode. The query list is in a list box.) Being able to access the Builder is my final hurdle.

    So... there it all is. Any ideas?

    Thanks in advance.
    Last edited by TheArkive; 11-14-10 at 10:11. Reason: Did more testing, fine-tuned my question.

  2. #2
    Join Date
    Feb 2008
    Location
    Fort Knox
    Posts
    32
    Sorry for the double post, but I've come a long way in just a few hours. Now I'm down to the final barrier: either this is possible, or it isn't!

    ================================================

    Ok, here is my next step. I accomplished the above so far by making a custom menu bar, instead of a custom shortcut menu.

    Here's the macro design:

    http://photoserver.ws/images/ce1Z4cdff89f361eb.png

    And here's a screenshot of the query design "invoker" i made:

    http://photoserver.ws/images/75BA4cdff92436b52.png

    When I click "Edit Query" the selected query pops up and the menubar lights up:

    http://photoserver.ws/images/LWqq4cdff92441796.png

    Yay it kinda works! But, it's not in a right click when I'm in QUERY DESIGN mode. Anyone know if it is possible to have a custom shortcut menu work in query design mode?

    I can even, get the menu to pop up in Datasheet mode! But not in Quer Design mode.

Posting Permissions

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