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.
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:
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.
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 09:11.
Reason: Did more testing, fine-tuned my question.