creating different filters for scrolling through forms?

hiccup

Registered User.
Local time
Today, 12:19
Joined
Apr 4, 2015
Messages
25
Hithere,

The last two weeks I taught myself Access (and hurt quite a few braincells in the process)
Yet I am getting close to what I want to achieve, but now I am stuck how to proceed with the following:

I want to have 'forms' view as my main interface for my records. This is working very nicely, and I like how I can scroll fast through all records with my mouse-wheel.
I also need to be able to filter records that will be displayed and scrolled through this way, and I created a filter which I can now toggle on or off easily for this purpose.

But now my challenge is, I want to be able to quickly select different filters, so for example, show only forms with a certain date field content. Or filter only forms which have a certain check-box checked. Etc. etc. And later on probably a bit more advanced, like: display forms that both contain 'this' and 'that'.

But I can't find a way to create several different and selectable filters?
So this should probably be achieved in quite a different manner?

Can somebody give me some hints please?

Tia!
 
...
Can somebody give me some hints please?
A combobox with the name of the different filters and some VBA code behind the combox's Update event, to create (or choose some pre defined filter(s)), + code for setting the filter(s).
 
Thnx JHB, but my first hurdle already is that I can't find the option to setup different filters?
 
I managed to set a simple filter through: Home > Sort & Filter > Advanced > Advanced Filter/Sort.
After that I can toggle it on or off through the button 'Toggle Filter'.
But I see no options to create a few different filters, and then easily select one of those.
(I hope this makes sense to you, I still hardly understand myself what I am doing)

Fyi, I asked this same question on another forum, and they advised me to try to accomplish this by means of 'datasheet forms', or 'filter by form', or something with 'unbound controls in the form header and the use of after update event'.
My newbee head is spinning with all this terminology, but it is very helpful to understand where I should try and find the solution.
 
..
Fyi, I asked this same question on another forum, and they advised me to try to accomplish this by means of 'datasheet forms', or 'filter by form', or something with 'unbound controls in the form header and the use of after update event'.
More or less the same as I wrote in post #2.
Post you database with some sample data, (zip it because you haven't post 10 post yet), + description of how you want some data filtered, then I'll make an example for you.
 
Thnx!
For this I just created a very simple database with only a few basic features that I think make it easy to understand what I would like to achieve.
In this example database I would for example like to have a few filters such as:
- Show records of the people who's birthday is today.
- Show all records where 'Done' is ticked
- Show records that have the action 'Visit', and check-box 'Done' unticked.

Ps,
And an unrelated question: in my actual database I can scroll through the forms with my mouse-wheel, but in this example database that doesn't work?
 

Attachments

Open the form "TheFilterForm" in the attached database make some choices in the comboboxes a click the button.
 

Attachments

Thanks JHB, much appreciated.
I believe this could help me on my way, but there are two things that work differently as I need them to.

Firstly, I would like preset filters that contain one or more rules in them. With your example I would have to select different criteria every time, and clear them again to select other criteria.

Secondly, I want only one complete form record in view at a time. Not all records which comply to the filter at the same time.

Would that be possible to achieve with the method you used?
 
..
Would that be possible to achieve with the method you used?
Yes - in my example I've shown you how to create and set a filter, so create the different filters you want as text strings and apply the choose one to the form.
 
Ok, with some effort I think I should be able to do that.
But the second point from my previous post is also very important. Is that also achievable?
 
I thought you've heard of Single forms/Continues forms/ Datasheet forms etc., set the form's property "Default View" to Single form.

By the way, did you read my signature? :rolleyes:
 
Nope, I am like a kid with the dashboard of an airliner in front of me ;-)

Thnx a lot JHB!
I'm gonna try to get this all to work in my real database now.
 
..
Thnx a lot JHB!
I'm gonna try to get this all to work in my real database now.
You're welcome. :)
Yes try to implement it and if you get problem then come back and ask for help.
 

Users who are viewing this thread

Back
Top Bottom