Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sorting of datasheet by clicking column header?

Posted on 2006-06-15
11
Medium Priority
?
210 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:Galisteo8
  • 5
  • 3
11 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 16913621
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
 
LVL 66

Expert Comment

by:Jim Horn
ID: 16913626
oops wrong link.  Hang on...
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 16913636
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 8

Author Comment

by:Galisteo8
ID: 16916404
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
 
LVL 58

Accepted Solution

by:
harfang earned 400 total points
ID: 16924040
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
 
LVL 8

Author Comment

by:Galisteo8
ID: 17142299
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
 
LVL 8

Author Comment

by:Galisteo8
ID: 17374497
Adding this sorting "feature" has been delayed due to other issues.  However, I do vow to get back to it.
0
 
LVL 8

Author Comment

by:Galisteo8
ID: 17554201
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
 
LVL 8

Author Comment

by:Galisteo8
ID: 17796513
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question