Detecting orderby

[Guest]

Hi,

Is there any way to detect if a user sets OrderByOn on a datasheet form?
There is on apply filter for filters, but I can't find anything for orderby.

I want to prevent changing the order of a datasheet. Is this achievable in
any other way?

Thanks in advance.


swas

 

[Damon Heron]

Have u tried setting RecordLocks to AllRecords?

Damon

 

[Guest]

another way would be to disable the shortcut menus, or create your own for
the datasheet form, so that the use cannot right click and select one of the
sort options.

 

[Guest]

Thanks for the thoughts Damon and Dale.

I don't see how recordlocks can affect a datasheet order, unless you mean by
locking other users out it doesn't matter if the order is changed. This won't
help me though.

Removing the ability for a user to change the order is the only way I can
see, as Dale says. At the moment this is my only option anyway, or when my
code runs that is effected by the orderby I can put up a msgbox giving the
option to clear orderby before proceeding.

Thanks again.


swas