Sort button

  • Thread starter Thread starter Anne
  • Start date Start date
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
 
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
 
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...
 
Back
Top