Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

choked filter

Posted on 2001-07-26
3
254 Views
Last Modified: 2008-03-06
i am using filter by form to view records by their machine code. if there are less than thousand records in the table, then in the filter drop down list, i can choose the machine code, and view all records matching that code

however, if the records in the table exceed thousand, then in the filter drop down list i only get null or not null. i can no longer choose the machine code.

it there any limit on records for filters. what should i do??
0
Comment
Question by:champs
  • 2
3 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 6321192
If the MachineCode is the main search criteria you could add a combobox based on a "SELECT DISTINCT MachineCode From YourTable;"
Thus you get all distinct codes and you can use the afterupdate event to place the selected value as a filter.

Idea?

Nic;o)
0
 

Author Comment

by:champs
ID: 6321235
i am not using forms or anything...this is directly from the open table...cant i directly do something...?
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 50 total points
ID: 6321279
Found in the Tools/Options window under the Edit/Find tab the field to set the number of displayed recordmax.
This can be enlarged to 32.000 but that's the real maximum.

Nic;o)
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question