I have a custom menu in my Access XP form. I can disable a subcommand very easily with the DoCmd.SetMenuItem action (e.g. FILE > PRINT, I can disable PRINT). However, I cannot disable a main menu command at all (e.g. FILE) . There is no error, but nothing happens. Does Access XP allow disabling of first-tier commands on a menu?
I did read about the CommandBar properties and actions, but the explanations and examples are too cryptic to make heads or tails out of them. It makes it look like you need lots of code lines merely to do this:
Code:
DoCmd.SetMenuItem 1, 2, , acMenuGray
Is there another way of doing it?
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division