cannot sort in tables?

N

Nick B

I found a few posts of this (in different versions of Access), but no
resolutions. We have a computer with Access 2002 that does not allow us to
sort. With a table open, the Sort Ascending and Sort Descending buttons are
disabled as is the option in the context menu. We've tried new and old
databases in 2000 and 2002 formats as well as databases with a single table
that work on other computers. Any ideas on this?
 
J

John Vinson

I found a few posts of this (in different versions of Access), but no
resolutions. We have a computer with Access 2002 that does not allow us to
sort. With a table open, the Sort Ascending and Sort Descending buttons are
disabled as is the option in the context menu. We've tried new and old
databases in 2000 and 2002 formats as well as databases with a single table
that work on other computers. Any ideas on this?
Click to expand...

<shrug> Use a Query. Queries can be sorted very flexibly; the query
can be opened as a datasheet just like a table, or (better) used as
the recordsource for a Form.


John W. Vinson[MVP]
 
N

Nick B

Thanks guys. I understand that sorting in a table is basically useless, but
the customer wants to do it. And since it is a feature of Access that does
not seem to be working, I'm trying to figure out why it is not working. If we
open a table with a text field, click in the text field, we want to be able
to sort, albeit temporarily, by that field. However, the sorting options all
remain disabled. On any other computer, using the same database, in the same
table, the sorting options work just fine.

:
 
N

Nick B

Thanks John. I agree with you 100%. But in this case it is a customer, so we
must give them what they want. I thought we covered everything from Detect
and Repair of Access to Office, even reinstalling Jet, to no avail.
 
Top