Data filter

shamal

Registered User.
Local time
Today, 09:21
Joined
Sep 28, 2013
Messages
86
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.
 

Attachments

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

Attachments

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?
 
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.
 

Attachments

Last edited:
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?
 
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.
 

Users who are viewing this thread

Back
Top Bottom