Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

Can't access menu item's shortcut text for custom menu item.

I have a menu bar, everything works great.

But the Shortcut Text is not available for entry. Can I access this? It's available for standard menu items (like Help - F1), but the Shortcut Text field is grayed out for my custom menu items.

One of my items is "Top 10 Issues", with the 1 underlined for hot key. So if you press
Alt, Search Menu, then 1, it queries on the top 10 issues, works great.

Then I have a hidden button with hotkey = 1, so if the user presses Alt-1, the button kicks in, which is the same action as the menu. I just can't access the Shortcut Text field on my "Top 10 Issues" menu option.
0
Alaska Cowboy
Asked:
Alaska Cowboy
  • 8
  • 5
  • 2
2 Solutions
 
puppydogbuddyCommented:
HI Bill,
If you use the Access Startup Property configurator, your problem could be related to the settings theron.....Go to   Tools>Startup Properties>>> then you'll see 4 settings for menubars and toolbars, including settings to allow changes to menubars and toolbars.

If your problem is not related to the above, then it is easier answered by linking you to a tutorial about creating custom menubars and toolbars:

                           http://www.jamiessoftware.tk/articles/menubars.html

The first half of the tutorial deals with creating Custom menubars and the last part of the tutorial dealing with popup menus relates to the shortcut menus.

Hope this helps.  At least, after reviewing the tutorial and you still have a problem, you will be able to point to  a  specific exhibit to provide more details of your problem.  
0
 
Alaska CowboyAuthor Commented:
PDB, thanks for the tip. I forgot about the Startup Properties, but it is checked (yes) to allow changes to menus and toolbars. I'll have a look at Jamie's site.
0
 
Alaska CowboyAuthor Commented:
PDB, in Jamie's tutorial, the Shortcut Text field is also grayed out . . . so maybe you can't get to it for custom menu items.

btw, I completely revised the look of my application, with a custom menu and toolbar(s) being one of the main revisions (and easy to do . . .)
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
puppydogbuddyCommented:
Bill,
You are really putting in all the bells and whistles....and I bet it has been exciting every step of the way!

Getting back to your problem at hand.  Which exhibit are you referring to in Jamie's tutorial.  If you look at Figure 15, where the shortcut menubar is selected, you should be able to look at (and change) the properties.
0
 
stevbeCommented:
<Shortcut Text field is grayed out for my custom menu items>
I've not spent much time on this but I have never been able to set this on my custom menu items either.

Steve
0
 
stevbeCommented:
OK ... I was just playing a bit more and while you can not get to it through the UI you can set it in code and even after you do that it does not appear while you are in customize mode but it does displaty properly when the app is running.

Application.CommandBars("BJs Data Menu").Controls.Item("Administration").Controls.Item(1).ShortcutText ="LLL"
0
 
Alaska CowboyAuthor Commented:
PDB, Figure 9 "ShortCut Text" is grayed out.

Yes, I'm had a lot of fun fixing the app. Mostly it's been the UI and installation procedures. I picked up Inno Setup and that is fantastic. I'll be sending it back to you around the end of May for another look.
0
 
Alaska CowboyAuthor Commented:
Steve,

Thanks for checking this out.

I added your code but it doesn't seem to work.

It compiles successfully but the ShortCut text doesn't show up when running the app.

I put this in my startup form:
    'To set the Shortcut Text for menu items
    Application.CommandBars("Info Manager").Controls.Item("Top &10 Items Only").Controls.Item(1).ShortcutText = "Ctrl + 1"
    Application.CommandBars("Info Manager").Controls.Item("&Show Search Fields").Controls.Item(1).ShortcutText = "Ctrl + 8"
    Application.CommandBars("Info Manager").Controls.Item("&New List").Controls.Item(1).ShortcutText = "Alt + J"

No shortcut text shows up . . .

I then put the code in the form_load event of the one form that uses this menu - Access choked on it.

Bill
0
 
Alaska CowboyAuthor Commented:
I also tried it without the & (just to be sure), but still nothing shows up.

this is pretty low priority, so no need for any extensive research or testing.

Thanks.
0
 
stevbeCommented:
I did not test it while the app was running, I only opened the database in design mode and ran the code from the immediate window.

Steve
0
 
Alaska CowboyAuthor Commented:
Ok, don't worry about it. Thanks for checking back.
0
 
stevbeCommented:
<I only opened the database  ...> but the setting was there the next time I opened the app so you only need to do this once during design.
0
 
Alaska CowboyAuthor Commented:
Steve, thanks again. I'd still like to replicate what you have done, but not able to do so.

(I never use the Immediate Window, never had it explained to me)

but anyway,
- My app is running
- I copied to the immediate window: Application.CommandBars("Info Manager").Controls.Item("Top 10 Items Only").Controls.Item(1).ShortcutText = "Ctrl + 1"
, then pressed Enter.

it said "Run=time error '5': Invalid procedure call or argument.

It compiles fine and when I de-bug it, it just goes its merry way past the statement without batting an eye - but not Shortcut text :-(
0
 
stevbeCommented:
not sure if this is your issue but  ... I displayed my custom menu before I executed the code.
0
 
Alaska CowboyAuthor Commented:
still not working, but thanks for checking back. It's really minor so I'll just keep it on my enhancements list . . .
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 8
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now