Sort button

A

Anne

My client want a form in datasheet view and be able to sort any one column
a-z or z-a
Is there a button one can use, rather then using the one on the access menu?
Anne
 
J

Jim Allensworth

My client want a form in datasheet view and be able to sort any one column
a-z or z-a
Is there a button one can use, rather then using the one on the access menu?
Anne
Click to expand...
Not in a datasheet.

But, you can use continuous forms for that. Put a label at the top of
each column, set it's Special Effect to Raised (for a button
appearance). And use the labels On Click event to change OrderBy. Here
is an example:

Private Sub lblStyleID_Click()
If Me.OrderBy = "StyleID DESC" Then
Me.OrderBy = "StyleID"
Else
Me.OrderBy = "StyleID DESC"
End If
Me.OrderByOn = True
End Sub

You might put some ControlTip text to provide a clue to the user, such
as "Click to sort by this column."

- Jim
 
A

Anne

Thank you, it works very well,
Anne

Jim Allensworth said:
Not in a datasheet.

But, you can use continuous forms for that. Put a label at the top of
each column, set it's Special Effect to Raised (for a button
appearance). And use the labels On Click event to change OrderBy. Here
is an example:

Private Sub lblStyleID_Click()
If Me.OrderBy = "StyleID DESC" Then
Me.OrderBy = "StyleID"
Else
Me.OrderBy = "StyleID DESC"
End If
Me.OrderByOn = True
End Sub

You might put some ControlTip text to provide a clue to the user, such
as "Click to sort by this column."

- Jim
Click to expand...
 
Top