Solved

Access ListView Box

Posted on 2013-05-27
6
64 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
6 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 250 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 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 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 57
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 84
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now