Filtering

D

Donna

I had a rather large table that I copied and renamed, then deleted many of
the obsolete columns.

Now the table only gives IS NULL/IS NOT NULL, when I try to filter the
columns for the values within the columns.

What happened when I copied and renamed? I see under options that the box
is checked that says "show values in local indexed fields". Does that mean
that the indexing got lost when I copied and renamed?

I changed one of the columns to indexed and now the values appear. What was
the proper procedure for copying, renaming.

The reason I had to do that in the first place was that I wanted to insert
another column and the original table gave me an error that said "Too many
fields defined" so I assumed that the table was too large?

Any clarification, suggestions for future greatly apprecaited. Now I'm
going to reapply the index set to "yes" for all fields if that is what is
necessary.
 
B

Brendan Reynolds

I just tested, and if I copy a table in Access 2003 by right-clicking the
table in the database window and choosing Copy from the pop-up menu, then
right-clicking and choosing Paste, the table is copied complete with all its
indexes. Did you copy your table in a different way?
 
D

Donna

I think I just copied/pasted as I would anything else and renamed it.
However, since my reports, forms, queries, etc. are based on the original
name after I copied it I switched the names of the original (now called
'Field Request prior to 8-9-05') and the copy (now called 'Field Request'),
so the copy ended up with the original name ('Field Request') so my queries
would work with the newly copied table. Hope that one make sense;)

That's the only thing I did different from a regular copy/paste. Would the
name switch have done something? Sounds doubtful, but hey anything goes....

When I compare the properties, options, etc. between the original table
('Field Request prior to 8-9-05') and newly copied table ('Field Request')
they all look the same. The 'indexed' property under design view is set to
'NO' in both tables yet the'Field Request prior to 8-9-05' table filters
properly.
 
B

Brendan Reynolds

Well, if there wasn't an index in the original table, then copying the table
certainly could not have caused the loss of an index that wasn't there to
begin with! :)

The default for filter by form is to show lists of values for both local
indexed *and* non-indexed fields, but not where there are more than 1000
records. Perhaps your table has more than 1000 records?
 
Top