Microsoft Access

[Guest]

How can I remove the filter/sort option in access 2002

 

[John W. Vinson]

How can I remove the filter/sort option in access 2002

Depends on the context. In code? in the user interface? in datasheet view?
across all tables?

Short answer: Records on the Menu, Remove Filter/Sort.

John W. Vinson [MVP]

 

[Guest]

When I open upwork sheet in access, I am able to enter data no problem,
without access puting all the numbers in a specific order, but as soon as I
close , then reopen the worksheet, all numbers go in 1-group in odd and even
numbers 2-then go into numerical order. How can I stop this?

Jason

 

[John W. Vinson]

When I open upwork sheet in access, I am able to enter data no problem,
without access puting all the numbers in a specific order, but as soon as I
close , then reopen the worksheet, all numbers go in 1-group in odd and even
numbers 2-then go into numerical order. How can I stop this?

A Table *has no order*.

A table is an unordered "bucket" of data. It's not a spreadsheet.

If you want to see data in a particular sequential order, you must - no option
- use a Query sorted by one or more fields in the table. If the records cannot
be ordered on the basis of some field in your data, you'll need to add another
field - a sequential Autonumber, or a Date/Time field with a default value of
Now() to timestamp each record, or some numeric field to manually define the
sort order.

It's best not to work in table datasheets anyhow - they have *very* limited
editing and display capabilities. Instead, base a Form on a sorted query, and
do your editing and data entry there.

John W. Vinson [MVP]