Data filter (1 Viewer)

[shamal]

Welcome..
Example of a school database
How to filter the data through the form using a check box, check box, or drop-down list to filter the data by Class and by Div
Thanks to all.

 

[CJ_London]

See this example

VBA to Apply/Remove Filters

Okay so 2 problems, first I want to apply a filter to a bound form that shows the dates that lie within a specific range. That range is the current year, current month and any day. I can't figure out the correct VBA for it, below is what I have. DoCmd.ApplyFilter , "[DateEnd] = Between...

www.access-programmers.co.uk

 

[arnelgp]

Open Main Form
and see the code on "Apply Filter" and "Clear Filter" of the Main Form.

 

[shamal]

Open Main Form
and see the code on "Apply Filter" and "Clear Filter" of the Main Form.

Thank you

 

[shamal]

Open Main Form
and see the code on "Apply Filter" and "Clear Filter" of the Main Form.

Welcome
How can I add a text box to search for names in the Main Form?

 

[Gasman]

Welcome
How can I add a text box to search for names in the Main Form?

Microsoft Access tips: Search criteria

Free sample database for Microsoft Access 2000 and later, demonstrating how to build criteria from many optional entries, and handle different field types, exact matches, partial matches, and ranges.

allenbrowne.com

 

[KitaYama]

How can I add a text box to search for names in the Main Form?

I was free and just was playing around with your file.
There are a lot of better (and safer) ways to do what you want, but just for the fun I did it this way.

I strongly suggest you to use @MajP 's method to create the filter in this post.

 

[shamal]

I was free and just was playing around with your file.
There are a lot of better (and safer) ways to do what you want, but just for the fun I did it this way.

I suggest you to use @MajP 's method to create the filter in this post.

Thank you

 

[shamal]

I was free and just was playing around with your file.
There are a lot of better (and safer) ways to do what you want, but just for the fun I did it this way.

I strongly suggest you to use @MajP 's method to create the filter in this post.

Can the search be part of the student's name and not the full name?

 

[Gasman]

Can the search be part of the student's name and not the full name?

Look at the link I posted, that is how Allen browne does it.

 

[KitaYama]

Can the search be part of the student's name and not the full name?

 

[mike60smart]

Can the search be part of the student's name and not the full name?

I would suggest that you think about Normalising your 1 Table.

A Student will sit a number of Exams.

If you wanted to add another Exam then this means you would need to modify the table which
is a no no in Access.

 

[shamal]

Thank you