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

x
?
Solved

Access ListView Box

Posted on 2013-05-27
6
Medium Priority
?
137 Views
Last Modified: 2016-07-05
Is there an Access Listview object I can use which works like the C# .NET one?

I would like the user to be able to drag columns, sort columns and perhaps right click to add/remove columns.

While the control is bound to a SQLQuery.

I also need multi-select.

I am currently using Access 2008, but could upgrade to Access 2010.

Thanks.
0
Comment
Question by:rowansmith
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 1000 total points
ID: 39200461
I would probably live with a standard datasheet view subform myself, but some developers use  Microsoft Listview Control version 6.0. which should be listed in your ActiveX controls.
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 39200737
There are also some 3rd party controls that do these things:

http://www.bennet-tec.com/btProducts/TList/TList.htm
http://www.codejock.com/products/controls/?2yn6s14z=p1z

But as Peter said, you'd be much better off either using the standard Access datasheet view, or switching over to a more compliant development environment.
0
 
LVL 58
ID: 39201038
Just to add a bit, the reason for the comments above is that Access does not have complete support for the IDispatch interface and many non-native controls simply don't work with it correctly.

If you do go with a non-native control, make sure it says that it can be used with Access.

Jim.
0
 
LVL 85
ID: 41691820
The user asked if there were any Listview controls similar to ones in .NET. The two answers below provided the answer (no, there is not) with workarounds:

https://www.experts-exchange.com/questions/28140163/Access-ListView-Box.html#a39200461
https://www.experts-exchange.com/questions/28140163/Access-ListView-Box.html#a39200737
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

783 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