Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datasheet sorting

Status
Not open for further replies.
simon373

simon373

Programmer
Oct 25, 2006
25
Hello,

I would like to sort (ascending by name) a datasheet. I can do so by right clicking the name tab and clicking sort ascending. Is there a way to automate this process so that I don't have to do it manually every time I open the datasheet? Using Excel I would carry out the sorting process whilst recording a macro. Then I would just need to run the macro every time the sheet opened.

Regards,

Simon.
 
Sort by date Sort by votes
Base your DataSheet on a query that has an OrderBy clause.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jsteff
  • Locked
  • Question
MSAccess Datasheet view does NOT show all columns in Table
Replies
6
Views
281
jsteff
jsteff
katrina11
  • Locked
  • Question
Sorting of numeric filed’s values is needed 2
2
Replies
22
Views
90
katrina11
katrina11
Pack10
  • Locked
  • Question
Sorting issue while Importing emails from group mailbox
Replies
5
Views
53
PHV
PHV
Pack10
  • Locked
  • Question
How to stop a query when its running or sorting
Replies
2
Views
206
Pack10
Pack10
Genie78
  • Locked
  • Question
sorting references for outlook and excel
Replies
6
Views
68
Remou
Remou

Part and Inventory Search

Sponsor

Back
Top