hfsitumo2001
Member
- Local time
- Today, 07:52
- Joined
- Jan 17, 2021
- Messages
- 365
Hello, I want to now showing menu of ms Access to users, but how can we make a filter that work like a filter in the ribbon. Anyone has sample?
Coz I plan to not showing the full menu on the front endWhy can't you just use the Ribbon? Plenty of examples available, depending on what you need.
Okay, not even a custom Ribbon?Coz I plan to not showing the full menu on the front end
What do you mean custom ribbon. What I see is just the ribbon on the upper menu of MS accessOkay, not even a custom Ribbon?
see in my attached form, I or user can put any comment to the record, then we can filter for the same comment, say "frequently used", I can filter using filter menu on the ms access ribbon, for all records with frequently used. But since I will not show full menu to users on the front end that I will distribute to them. How can I make a filter that can reach that purpose.Okay, not even a custom Ribbon?
You can create your own Ribbon, so you can control what the user can do.What do you mean custom ribbon. What I see is just the ribbon on the upper menu of MS access
See posted example.How can I make a filter that can reach that purpose.
Did you post an example MajP?, where is itSee posted example.
Thank you MajPPost #4?
So the example is how to filter like the ribbon. In my example I used the FilterMenu but you want a Docmd.RunCmd FilterBySelection. I do not think I would ever build an interface like that because filtering a form by selection in single form view makes little sense to me. I would probably have other filter interfaces. However, this demonstrates what you asked if you can do a filterbyselection like the menu.but how can we make a filter that work like a filter in the ribbon. Anyone has sample?