how completely clear filter
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » How to completely clear a filter when in form view

How to completely clear a filter when in form view

resolvedResolved · High Priority · Version 2007

replyReply Fri 23 Jan 2009, 10:52Delegate Sarah said...

Sarah has attended:
Access Introduction course

How to completely clear a filter when in form view

Hi,

I have a form which brings up a long list of company names - users need to be able to quickly find the company that they are looking for, however the exact name is rarely known. What I have done is to place buttons on this form with the aim to run filters as per the users request.

e.g.
Button "Find company name that starts with [letters]"
I have set this to run a macro which applies a filter such that it will ask you to: Enter first few letters

This is great and brings up exactly what we asked for - I have also placed a button with the action to "Remove all filters".

However, even having removed this filter so that all companies are once again visible, if the user then wants to look for another company with DIFFERENT starting letters, the Button no longer asks: "Enter first few letters" and automatically filters the form again to their previous input.

How can I resolve this?! at the moment I have taken the long way round and I have each button opening a new (almost identical) form which is based on that particular query. I really do not think that this is the best way and I would love for users to only have one Company Names form open which tends to all their search needs.

Thank you for your help!

For upcoming training course dates see: Pricing & availability

replyReply Mon 2 Feb 2009, 20:03Trainer Rajeev said...

RE: How to completely clear a filter when in form view

Dear Sarah

Thank you for attending Access Introduction Course!! I hope you enjoyed the course and benefited from it.


I personally think that you can achieve the same thing by using Parameter Query. This will eliminate the resetting of the filters, etc...

We do cover Parameter Queries in our Intermediate course but I'll give you some instructions for creating a parameter query.

You can create a normal query and download all the fields that you wish the users to see in the "Company Name" field you can type the following in the criteria box:

Like [Enter first few letters of the Company] & "*"

This will provide you the same results.

After creating the query you can simply create a form based on it.

Please find the below link to see what other topics our Access Intermediate course covers and also the schedule:

http://www.microsofttraining.net/access-2007-intermediate.php

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Mon 9 Feb 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft database training and other Microsoft training courses.

Access tip:

Change case

To change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard