469,267 Members | 971 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

Why is sorting in the database view bad? (Form Properties > Datasheet View)

Why would one not want to sort records in a form using Form Properties
Datasheet View > Sort Ascending?


It's the fastest way, isn't it?

Nov 13 '05 #1
2 1706

<si*********@gmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Why would one not want to sort records in a form using Form Properties
Datasheet View > Sort Ascending?


It's the fastest way, isn't it?


No, the fastest way would be to sort in the Query or SQL you use as Record
Source for the Form, I suspect. I don't give the users "datasheet view" in
the database applications I prepare, because there are so many things that a
user can (inadvertently) do that will cause trouble.

Generally, datasheet view is useful for end-users, not for developed
application and the "Windows Way" is to let the user have control of their
own desktop unless there is compelling reason to not do so. I can't think of
a compelling reason not to allow this, if it is what the user wants to do.

Larry Linson
Microsoft Access MVP

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2
It converts the underlying query to DISTINCT, so you
may have a different number of records after sorting.

(david)

<si*********@gmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Why would one not want to sort records in a form using Form Properties
Datasheet View > Sort Ascending?


It's the fastest way, isn't it?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Georges Heinesch | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.