Advertisement

05.17.2008 at 06:47AM PDT, ID: 23410623
[x]
Attachment Details

Use menu item "find" and filter result

Asked by emacyam in Microsoft Access Database, Access Coding/Macros

Tags: Microsoft, Access, 2003, find and filter

Hi,

I need help in incorporating the "find" menu item on my form and then filter the result with whatever the user input in the "find" box.  Is this possible?

What I need to achieve is as follows:
1)  User clicks on the find button
2) User types in the data on "find what"
3) User hits enter or find next
4) Form gets back control which is now filtered based on the data that the user entered in find (customer number).
5) A button that would remove filter on form and resets find button.

What's the best way to do this?  I am hoping to use the menu item "find", filter result.  Any suggestions?

Thanks!
Start Free Trial
 
Keywords: Use menu item "find" and filter result
Title
1 spam filter for my email
2 Pop-up menu design...
3 Dynamic Menus and XSLT
4 Remove filter/sort
5 Excel - Add filter on the header top row
6 VBA Enable Shortcut Menu Bar?
 
Loading Advertisement...
 
[+][-]05.17.2008 at 07:48AM PDT, ID: 21589534

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 07:49AM PDT, ID: 21589539

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 09:27AM PDT, ID: 21589953

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 10:09AM PDT, ID: 21590084

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.17.2008 at 02:38PM PDT, ID: 21590837

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.18.2008 at 12:06AM PDT, ID: 21591803

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 02:25AM PDT, ID: 21592062

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 08:02AM PDT, ID: 21592908

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 09:34AM PDT, ID: 21593218

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, Access Coding/Macros
Tags: Microsoft, Access, 2003, find and filter
Sign Up Now!
Solution Provided By: DatabaseMX
Participating Experts: 3
Solution Grade: A
 
 
[+][-]05.18.2008 at 01:52PM PDT, ID: 21593986

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 03:29PM PDT, ID: 21594306

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 03:52PM PDT, ID: 21594378

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 06:49PM PDT, ID: 21594823

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628