Jamie Roberts
asked on
Custom Ribbon disappears in Filter By Form
I have an Access application that I have finally converted over to use a custom Ribbon. I am a bit of a novice using the ribbon, but learning. My problem is that when a user clicks on 'filter by form' from the ribbon, the form opens in filter mode BUT the ribbon disappears...no way to apply the filter.
The custom ribbon name is set as the form ribbon, but I'm not sure if I need to specify a different ribbon in VBA for the 'on filter' event or if I can specify the same filter or where exactly I go from here.
The custom ribbon name is set as the form ribbon, but I'm not sure if I need to specify a different ribbon in VBA for the 'on filter' event or if I can specify the same filter or where exactly I go from here.
Have you tried toggling the "Allow Full menus" and "Allow Default menus" off?
ASKER
The configuration I use is "Allow Full Menus" off, "Allow Default Shortcut Menus" off, and "Allow Built-in Toolbars" on, but I've tried all off, all on, etc. but it doesn't seem to make a difference. I have a function 'FormSetUp' that runs on Form Open and sets default values/textbox colors/etc. that also sets the ribbon if Access.Application >= "12.0", and I've gone through each form manually and set the ribbon...so:
1) The application Ribbon is set in Access Options-->Current Database
2) I have code that runs on form open that programatically sets the Ribbon
3) I manually set the Ribbon on each and every form.
But still, when I go to 'Filter By Form' the Ribbon vanishes.
1) The application Ribbon is set in Access Options-->Current Database
2) I have code that runs on form open that programatically sets the Ribbon
3) I manually set the Ribbon on each and every form.
But still, when I go to 'Filter By Form' the Ribbon vanishes.
ASKER
Attached is a sample file. Just run this, open the form 'Tradecodes' then using the ribbon go to 'filter by form'.
Example.zip
Example.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Unfortunately, it appears that you're right. FbF is apparently a builtin function, and it looks like Access takes over when you select FbF. Looks like to use FbF with a custom ribbon I have to allow built-in toolbars and modify the built-in ribbon. I customized the built-in ribbon and removed everything except the 'Home' tab and the 'Sort&Filter' items. When I go to FbF, THIS ribbon appears (the built-in one I edited in the Options-->Customize Ribbon), so, now my user can at least click 'Toggle Filter'.