Hi,
In tables I have up/down arrows in each column header allowing me to sort the data by that column.
How can I do this in forms displaying tabular data - ie. add up/down arrows to each column header in the form?
Thanks for any help
David
Hi,
In tables I have up/down arrows in each column header allowing me to sort the data by that column.
How can I do this in forms displaying tabular data - ie. add up/down arrows to each column header in the form?
Thanks for any help
David
Form must be in Datasheet view.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Continued searching, and found that right clicking in a cell of a tabular form gives the option to sort the data by that column.
Guess that's the closest I'm going to get?
Thanks
David
Hi June7, Tried Datasheet view, displayed only a single record and no sort arrows
Works for me. Maybe you need to provide image or database.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi June7,
Here's the accdb - zipped
Thanks
David
The form is in Continuous view, not Datasheet.
AllowDatasheet property is set to No.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
In datasheet view can I put command button on each row?
You can program this functionality into a continuous form , something like (Assuming your field was called Status)
You could also change the label to reflect the change.Code:Private Sub Status_Label_Click() ' reorder data on form sort by status If Me.OrderBy = "Status" Then Me.OrderBy = "Status DESC" Else Me.OrderBy = "Status" End If Me.OrderByOn = True End Sub
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
No, buttons are not available in Datasheet view, however a textbox can be made to act like one.
If sorting is all you want, not filtering, then Minty's suggestion may be appropriate.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
For an example using a continuous form see the Student Target Grade Explorer example http://www.mendipdatasystems.co.uk/m...ter/4594454290
Thanks for all your help,
Much appreciated
David