Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

choked filter

Posted on 2001-07-26
3
Medium Priority
?
282 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 200 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

564 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