Sorting of datasheet by clicking column header?

Am wondering... If I have a subform that is in datasheet view, is it possible to sort by a given column just by clicking on the column's header/title (rather than right-clicking and selecting Sort Ascending)?

--Galisteo8
LVL 8
Galisteo8Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
harfangConnect With a Mentor Commented:
Hello Galisteo8

I also have an answer to this somewhere on this site (^v^)

Check out {http:/Q_21612585.html#15186788}, it uses the actual column headers as buttons to perform a sort on that column.

Cheers!
(°v°)
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Here's my handy-dandy way to simulate an Excel spreadsheet in a subform, which has command buttons that let you sort columns
http://www.experts-exchange.com/Databases/MS_Access/Q_21498212.html

Hope this helps.
-Jim
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
oops wrong link.  Hang on...
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
0
 
Galisteo8Author Commented:
Jim,

The subform in question is based on a query that pulls data from two different tables.  Even just using the built-in sort function, it balks at me ("The column prefix doesn't match with a table name...").  Is subform's query-based nature an issue that would prevent your solution from working?
0
 
Galisteo8Author Commented:
Posting to keep this thread open for a bit longer.  Issue not yet resolved.
I still need to check out Harfang's URL.

Thanks!
0
 
Galisteo8Author Commented:
Adding this sorting "feature" has been delayed due to other issues.  However, I do vow to get back to it.
0
 
Galisteo8Author Commented:
Been off this project for almost a month due to sick time with family.
I apologize for the delay in resolution.
Will be back on it within a couple of weeks, hopefully.
0
 
Galisteo8Author Commented:
I did not realize that so much time had passed.  I am only just now getting back to this project, but am inclined to close any outstanding questions on this and some other related issues while I get back into the groove of things (e.g. figure out project status).

I am very sorry for letting this question linger without resolution. I'll put in a close request.  As I move forward on this project, I'm sure this issue will pop up again in some way; I'll start a new question if/when that happens.

Thanks to everyone who chipped in previously.  Please accept my apologies.

--Galisteo8
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.