Solved

Sorting of datasheet by clicking column header?

Posted on 2006-06-15
11
195 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
11 Comments
 
LVL 65

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 65

Expert Comment

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

Expert Comment

by:Jim Horn
ID: 16913636
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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 100 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

739 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