filter form

[hfsitumo2001]

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?

 

[theDBguy]

Why can't you just use the Ribbon? Plenty of examples available, depending on what you need.

 

[hfsitumo2001]

Why can't you just use the Ribbon? Plenty of examples available, depending on what you need.

Coz I plan to not showing the full menu on the front end

 

[MajP]

The Most Powerful form Filter and Requires almost No Code

NOTE: See updated code below. I recommend using the updated class module that @arnelgp modified. It further simplifies building a search form and addresses some bugs...

www.access-programmers.co.uk

 

[theDBguy]

Coz I plan to not showing the full menu on the front end

Okay, not even a custom Ribbon?

 

[hfsitumo2001]

Okay, not even a custom Ribbon?

What do you mean custom ribbon. What I see is just the ribbon on the upper menu of MS access

 

[hfsitumo2001]

Okay, 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.

Thank you

 

[theDBguy]

What do you mean custom ribbon. What I see is just the ribbon on the upper menu of MS access

You can create your own Ribbon, so you can control what the user can do.

 

[MajP]

How can I make a filter that can reach that purpose.

See posted example.

 

[hfsitumo2001]

See posted example.

Did you post an example MajP?, where is it

 

[MajP]

Post #4?

 

[hfsitumo2001]

Post #4?

Thank you MajP

 

[MajP]

So the question was

but how can we make a filter that work like a filter in the ribbon. Anyone has sample?

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.

I reused the same data set and not very good for demonstrating. Filter on supplier name since that repeats.

 

[hfsitumo2001]

Thank you MajP, that's exactly what I need.