J
Jason
How can I remove the filter/sort option in access 2002
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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]
J
Jason
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
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
J
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]