Solved

Custom Ribbon disappears in Filter By Form

Posted on 2013-01-29
5
1,140 Views
Last Modified: 2013-01-30
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.
0
Comment
Question by:Jamie Roberts
  • 3
  • 2
5 Comments
 
LVL 84
ID: 38832350
Have you tried toggling the "Allow Full menus" and "Allow Default menus" off?
0
 

Author Comment

by:Jamie Roberts
ID: 38832408
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.
0
 

Author Comment

by:Jamie Roberts
ID: 38836951
Attached is a sample file.  Just run this, open the form 'Tradecodes' then using the ribbon go to 'filter by form'.
Example.zip
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 38837127
I would suspect this is because Filter by Form is a builtin Access mechanism and therefore uses it's own internal settings (which would obviously include a ribbon specific to the task of filtering a form).

If you need advanced functionality like this, you'll have to 'roll your own' filter by form mechanism, and when doing this you can define your own ribbons and such.
0
 

Author Closing Comment

by:Jamie Roberts
ID: 38837242
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'.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now