Visual Basic :: Ordering Columns In A List View

Listview Columns In List View
I am trying to use Listview to import data from an Access table and I only want to use the list view not the list report. The data imports OK and populates the list OK into (in this case with the quantity of data imported) 4 columns.

Trouble is, all the data is truncated and I can find no way of setting the column widths as you can in the normal list box. I do not have any sub-items, just a single list so I do not need to set up any column headers.

List View Select - Multiple Columns
I have a listview control with two columns...

1. File Name
2. Extension

When I selected the file I return the file name, but if i want to retrieve the properties regarding the file i need the extension which is in column 2...

This will get the information in column 1 (File Name)

Set objFile = objFSO.GetFile(DirList.List(DirList.ListIndex) & "" & lstFileList.SelectedItem.Text)

How do I get it so that it gets the info in column 1 and adds the info of column 2 to that string? i.e.

file name extension
mydoc doc
myvideo avi
myemail eml

i want it so that when i click on mydoc the string becomes... mydoc.doc, any ideas? thanks
- gabe

How Do I Hide/unhide Columns In A List View?
I want the user to choose the columns for a specified output though all the columns will be filled

with data , i want to display only those columns which the user selects.Currently i make the width

of the hidden column as - 0 but that the user can just keep his mouse on the header and drag to

see the hidden column. How do I actually hide it???

Sorting On DATE Columns In MS List View
Does anybody know how to get this to work?

The listview seems only capable of accepting strings as it's items so dates have to be converted to text and therefore are sorted as text.

How can I get around this?

Freeze The Columns Of List View Control
Hi Gurus,
I want to freeze the columns of a Listview control in Report view mode. Is there any property of List View or any other code example to show me how to prevent the columns to be resized by the user?

Help me plz, it is really necessary.

Waqas...

List View Find Text By Corrosponding Columns
Hi, i have a list view with 2 coumns and it retrieve information from a server and it contains different amounts of information at once.

What i need to do is locate in the first column of the listview anything containing
the index "hostname" then go retrieve the hostname which would be in the next column in the exact row. So it looks like this

Column 1 - Column 2
=====================
ip add - 192.168.blahblah
hostname - TheTestName

i want to retrieve "TheTestName" by finding the column "hostname" but i have no ideas how to achieve this. If anyone could help me out that would be great.

2 Qs : Timer And How Do I Hide/unhide Columns In A List View?
hi,
2 questions
For a listview, I want the user to choose the columns for a specified output though all the columns will be filled with data , i want to display only those columns which the user selects(Like we have it in windows explorer). Currently I make the width of the hidden column as - 0 but that the user can just keep his mouse on the header and drag to see the hidden column. How do I actually hide it???

Second question:

I have just recently find out that one cannot set the interval time of a timer for than 65000 millisecs that is apporx a minute. How do I set the interval of a timer for more than a minute say 3 minutes?

Thanks.

How To Sort Columns In List View -- Just Like Windows Explorer
Hi,

I am using ListView Control.. I want to sort the listview on a particular column when user selects it. Is there any direct way of doing this.. And can I set colors to rows in a Listview control.. Like I have a situation where I want alternate colours to be displayed.. Is it possible

Regards

Surya Prakash

Ordering Columns In Data Sheet Via VB
Can you order the columns in a datasheet view via VB?

I am entering data into a datasheet that has many more columns than the screen can hold but need to be able to get to all columns quickly. It would be nice to be able to just hit a button to move the columns I need all the way to the left or wherever. I know you can click and drag the columns with the mouse so it seems like you could do it with code.

Thanks.

Ordering Records Problems In Form View
Hi,

First off, thank you to everyone who helped me with my two previous questions in the past couple of days.

Right now I'm experiencing something that seems like a bug. I've been entering information into a table via a form for a while now. The key to the table is an ID number and the records in form view are, for the most part, ordered according to this ID number. The problem I'm experiencing is that record #14 always ends up as the last record and I have no idea why. It shows up in the correct place in the table. Is there any way for me to fix this or to force the records to be ordered like the rows in the table (in VB or just by setting some sort of preference in Access)?

Thanks. Best,
Giacomo

Ordering A List Box By Date???
Set the propertiy Sorted = true in the Properties window. That sorts the date from newest to oldest.

Visual Basic List View Control To View Network Computers
Hi,

I am working on simple network connect utility and ready with the functinality. But I am stuck at a very important aspect of the GUI where I need a List View Control that will view the computers from the available LAN domains. And will let us select a particular computer on expanding the domain List Item. If not a list view then a treeview rather.

Also will this control let me select a NETWORK COMPUTER ONLY but not shared folders on its individual drives. Only computers has to be selected. Not the nodes (folders) shared at them.

Thanks.

Vinitsankhe.

Windows File Explorer.. Icon View And List View.
I'm trying to duplicate a function of the explorer.. The folder contents view.

See example of what I mean...
http://www.ibarn.net/fun/files/thumblist.jpg

I can do everything I need using the filelistbox with the sole exception of changing the display style. I don't want a file list, I want a list-view or icon-view. (Preferably both, with the option to switch between them.)

So my question to you fine people is...... what API or component could I find this capacity in? I've looked at all of the components and didn't see anything that looked close, and a search on the subject yeilds hundreds of people trying to emulate the "filemanager" explorer style, but none trying to kick out a normal, boring icon view like this.

Any help would be greatly appreciated.

Thanks.

List View PopUp Prob (lvwIcon View) *Resolved*
Hi all,

I have a listview in large icon view (lvwIcon). I have a popup menu displaying some options when the user right clicks an item that is specific for that item.

My question is this -

I want a different popup menu to show when the user right-clicks on a blank area of the listview which would display general options.

In my testing, whenever a blank area is clicked, the selected item is the first item (if none had been selected) or the current selected item (if one had already been selected).

I currently use the selecteditem.text to determine what pop up menu is to be used.

I guess in theory the code might be something like ;

Code:
If lvwMain.SelectedItem = Nothing then
PopupMenu mnuGeneral
Else
PopupMenu mnuSpecific
End If

Any help would be greatly appreciated.

Cheers

Jack

Matching List View To Tree View
Hi Everyone,

Quick Question. I have a list view and a Tree view that are sharing the same data. The Tree view control lists all the Task Names and the List view control has the task detail. (Start, End Date and resources.)

The only issue is that the Line widths do not match. The Tree View nodes have more white space between them then the list view. Is there a way that I can match the width of the tree view rows to the rows on the List view?

Thanks
BDS

How Can I View The Data From A Table In List View?
Please let me know how can I view the data from a table in List View?

How Can I View The Data From Table In List View?
Please let me know how can I view the data from a table in List View?

List View, Tree View Controls
I have had the same problem... I ended up righting my own controls so that it would run faster on the population of the control...

Sorry
Brooke

Removing Columns From Datasheet View
Hi all, please help!

I have a subform (in datasheet view) that has to show/hide different columns under different contexts.

I tried

mytextbox.visible = false

where mytextbox is a textbox in the subform. This hides the textbox in Form View, but doesn't do the trick in Datasheet View.

I also tried

mytextbox.ColumnHidden = true

This method hides the column in the datasheet, but the column is still in the datasheet. So the user can bring the hidden column back by resizing the column (dragging the column header).

It there any way to truely hide/delete/remove a column from a datasheet view???? I've looked everywhere on web, but in vein.

Any help would be greatly appreciated! Thanks in advance!!!

-- kothreat@yahoo.com --

Moving Columns On A Listview (Report View)
I want to programmatically set the Position of the columns in a list view.

This is an "after thought" so I am trying to do it on already loaded listviews.

I see from a little experimentation that I can easily move the column headers by simply changing the .position property.

But that does not bring over the data for that column. (Just the header)

Do I have to manually move the data or there an easier way?

(By "manually move the data" I mean set up a temp array, copy the column's data, update new column after moving other column into original col number)

Regards,

Activex Controls For List Box, List View & Combo Box (for Storing Arabic Language)
Hi all,

Can any one having controls (list box, list view , combo & date
picker ) with right alignment. i.e scroll bar should come in left side
instead of right...simalry drop down for combo box should be in left side
instead of right side.

This i need for storing Arabic data...

Thnaks
Sridhar CS

Select Folder Dialog. List All Folders And Subfolder In List View
Hello all.

I am trying to select a folder in a folder dialog. I then want it to list all the folders and subfolders and files within the selected folder in the list view.

this is what i have so far. It just lists all the first children folders of the selected folder. any help on this?

Code:
Private Sub addFolders()

FolderBrowserDialog.ShowDialog()

ListView1.Items.Add(FolderBrowserDialog.SelectedPath) 'lists top selected folder

Dim STF As New IO.DirectoryInfo(FolderBrowserDialog.SelectedPath)
Dim F As IO.DirectoryInfo
'lists each folder inside top folder
For Each F In STF.GetDirectories()
ListView1.Items.Add(F.Name)
Next

End Sub

List Box - How To Have Left && Right Aligned Columns In The Same List Box.
Hi,

Excel 2000, VBA

Is it possible to have the different columns with left & right alignment in the same list box.
ie. columns 1 & 2, left aligned and column 3, right aligned.
One way I can think of is to place another list box over column 3 of the first list box, but it does make for fiddly coding.
I've googled, but not found anything. Any suggestions welcome.

Regards

Editing List Items And ListSubItems In List View Control
Hi,

It is possible to edit ( add an entry ) the first column of a ListView control. By setting to automatic mode.

How do I edit the subsequent columns ( The listSubItems ).

BB

What Is The Limits On COmbo Box, List Box And LIst View And How Do You Handle Situations W
OK<
I have looked at all 5 of my vb Barnes and noble books
under listbox
and did not find where it said what the limit was.

I learned how to read a data base (unbound even) into a list box, or combo box.

But now I have over 32,768 items,
my data base list has between 100,000 - 125,000 Parts I want to load.

I can think of a lot of cases where the data base you want to load into a list or combo box is well of 32768

So my questions are
( I did also search VBCITY)

1) What is the limits on
listbox
combo box
list view

and

where is it documented.

and 2

How do I handle the case of more than 32768 with a listview??

I did found a little bit about it on vbcity

Thanks

Changing To A List View Instead Of A List Box To Overcome 32768 Limits
I had the program done
I was loading a listbox and typing is a text box watching the closest match be selected.
I start off by filling the list box from a mdb with a table called partlist,
and a field called part numbers

It worked fine.
But now because I am over 32768 ( I will never go over 125,000) records, I am past the usefullness of a list box I guess.

so How do I change this code that works with a listbox, to code that works with a viewbox

and is this my best solution

Here is the listbox working code

Public Function FillListboxparts(Optional PartNumber As String)
   Screen.MousePointer = vbHourglass
   Dim li As ListItem
   Dim lih As ListItem
   Dim cnn As ADODB.Connection
   Dim rsPartList As ADODB.Recordset
   Dim strSQL As String

   strSQL = "SELECT PartNumber From partlist"


   Set cnn = New ADODB.Connection

   cnn.Open ConnString
   Set rsPartList = New ADODB.Recordset
   rsPartList.Open strSQL, cnn

While Not rsPartList.EOF
    listboxparts.AddItem rsPartList("Partnumber")
    rsPartList.MoveNext
Wend
Text1.Text = listboxparts.ListCount
rsPartList.Close
Set rsPartList = Nothing
cnn.Close
Set cnn = Nothing

Set li = Nothing
Set lih = Nothing
  Screen.MousePointer = vbDefault
  End Function

How To Change Back Color Of List Item In List View
Dear members,

i am having small problem with listview control , I want to assing alternate colors to list items, but i con't,

hope someone will help

regards
D.L.Narayana

Tree View + List View
Hai,

In my application, I have Tree view on left side and List view on the right side which is just like windows Explorer. I would like to get the same functionality like Explorer where you can move the seperator between Tree View and List View. That means I would like to make the List View wider or shorter as I wish.

Can any body help me?

Thanking you in anticipation

Selected List View Field To List Box
hi,

I Have list view control with check box, when i select the record the record to be displayed in list box,The event is geting trigered but the problem is that if i have multiselction or another row selection the exiting record disappears from the list box.

*RESOLVED* Getting Selected Item In List View To Move Into View*RESOLVED*
Hi, I am trying to get a List View to act like a combo box. At the top of the List View there is a text box where the following code searches the List View for the text entered, I have this code in the Change event of the text box so a search is done on each letter typed.

The code finds the record without a problem but I want it to move to the top or into view. Right now I have to scroll down to find the record it selected. Anyone have any ideas? Here is my code:

Code:
Private Sub txtFindFirst_Change()
Dim i As Integer
Dim l As Long
On Error GoTo NoRecord

If txtFindFirst = "" Then
GoTo NoRecord
Else
l = Len(txtFindFirst.Text)
For i = 1 To lstContacts.ListItems.Count Step 1
If StrConv(txtFindFirst, vbUpperCase) = StrConv(Left(lstContacts.ListItems(i).Text, l), vbUpperCase) Then
lstContacts.ListItems(i).Selected = True
Exit Sub
Else
End If
Next
End If

NoRecord:
On Error GoTo NoList
lstContacts.ListItems(1).Selected = True
strTransferID = lstContacts.SelectedItem.ListSubItems(1).Text
Exit Sub

NoList:
Exit Sub
End Sub

Thanks in advance for any help.

List View List Subitems Help
Hi guys,

Im generating a time based values which im adding to my listview (report style) under three columns before a new row is generated. Now i want to add another value to column 4 nly how do i do that??

i think it has something to do with:

Set listsubitem1 = listitem1.ListSubItems.Add() ????
but i want to add under column 4 continously??
help!

Columns In A List Box
Well then I am wanting to make 3 columns in a list box. So I thought it would be as simply as padding each value so it holds 20 spaces using this function:

Code:
If txtName.TextLength < 20 Then
For i = 1 To 20 - txtName.TextLength
txtName.Text = txtName.Text & " "
Next i
End If

The other two variables are constant size so there was no need to change them, the values are stored in a textfile and updated using the method below. When you view the text file they are pefectly placed in it but when I update the listbox, the spacing goes wrong. Any ideas why?

Code:
Public Sub updatelstbox()
On Error GoTo errorhandler
frmContact.lstcontact.Clear
Dim dump As String
Open "M:Messageuserdata.txt" For Input As #1
Do While EOF(1) = False
Input #1, dump
frmContact.lstcontact.AddItem (dump)
Loop
Close #1

errorhandler:
Exit Sub

End Sub

So in a nut shell from a perfectly spaced textfile updating it to a listbox it doesn't show the values correctly any ideas why?

- Further clarification just ask

List Box Columns
Can anyone tell me how to set the column headings of a multi column list box? I have 3 columns and the headings are visible.

Thanks
Andy

List Box With Several Columns
Hello everybody,

I´m searching for a list box with several columns. The difference to the "standard"- ListBox of VB should be that a new element isn´t add underneath the last element, but beneath the last element. This means, the list box should be sorted from left ro right, not from top to down.

Does anybody know a box with this options ?

Every idea appreciated

-Mario

List Box Columns
I am using list box in my program. I have seen the columns option in its properties.
When i change it to 2 it divides whole list box in 2 columns. The columns are not visible but when i select items on runtime only the half part is highlighted.
It also add items in only first column. How can i add data in second column.

List Box Columns
Hello,

I have two text boxes and a list box which has two columns, i also have a command button called add. How would i go about adding the first text box to the first column and the second text box to second column of the list box.

Jenova

Using Columns In A List
There is a simple list in which I put 2 columns
How do I add a row? (more precisely how do I enter a element in the second column?)

lstSomething.AddItem strSomethingElse puts me a string in the first column.

List And Columns
Does anyone know how to make those nifty multi-column list boxes? The ones that are in almost every program you see now? I've tried to figure it out and I decided it would just be best to ask here.

List Box With Columns
Hi, how do I create a lsit box that has headings and columns in it, i have seen this done in other programs and want to know how.

What control is it i use?

Thanks for any help.

List Box Columns
Does anyone know how to referance the different cols in a list box.
I have a list box (List1) with two coloums, and i want to add data into the first col and then the second.

Any ideas??

Thanx

List Box Columns
I am using a list box to allow users to make multiple selections (checkboxes) but I also want to list other columns of data for each selection. Is there a way to create multiple columns of data for each checkbox that displays in the listbox? Or allow a user to edit data - like you could in a grid. Or now I am thinking I may have to try to put checkboxes in a grid - but how would I do that? Suggestions please.....

Columns In A List Box
How do I use multiple columns in a list box. Can I use different justification in each column (i.e., left justify column 1, right justify column 2). I am new to VB (and programming in general) if this seems to be a simplistic question.

I need to display two columns in a list box.

Column one has categories and column two displays dollar amounts . Obviously I want the dollar amounts to align decimally.

I am sure it can be done, but how.

Thanks for your help in advance.

List Box Columns Headings
Can anyone tell me how to set column headings in a multi column list box?

Thanks
Andy

Fill Columns In List
How to add (and read) text in a column of a listbox?

Additem only writes in the first column :S

List Box Uestion Regarding Columns
Hello,
I'm loading a list box with 3 fields of a recordset. I'm running into a problem trying to line the 3 fields up in columns. I'm not using columns right now. I'm moving the 3 fields into certain positions of string field and then using that string field in the listbox.additem statement. Here's and example.
Mid(strListboxfield,1,5) = rs!fielda
Mid(strListBoxField,8,40) = rs!fieldb
Mid(strListBoxField,51,10) = rs!fieldc
with listbox
.additem strlistboxfield
end with
The problem I'm running into is when the listbox is displayed none of the fields look like they are in columns. It basically looks like each field was appended right after the previous field.
Is this something that could be fixed by using columns? If so, is there a way to do that with out having a horizontal scroll bar? I've tried using columns, but it seems to be loading everything horizontally and not vertically.
Thanks in advance.

Multiple Columns List
In Access, you can make multiples-columns ComboBox.

For example, you can determine the ComboBox content by a sql query. Then, if this query return 3 fields, you can set the Columns property to 3 and the ComboBox display the 3 data for each row.

I want to do the same thing with Visual Basic: filling a ComboBox with data from an Access database.
But is it possible get more than 1 column in the ComboBox?

List Box And Columns Alignment?
Is there away to align fields in a listbox, maybe by using tabs or some sort.

What I have is a Search form which now end up with about six columns.

I've been trying to convert the code in my module to use a mshflexgrid but could only get information into one column. I've never use mshflex or any grid before. I thought it would be better then the listbox.

Any ideals.. I just don't like the listbox with lines that looks like s curves.

This is what I got in a module:

Code:
Dim rs As ADODB.Recordset
Dim db1 As ADODB.Connection

Public Sub findCustomer(brandname As String)
Dim nom, lnom As String
Dim results As Integer
results = 0

Set rs = New ADODB.Recordset
Set db1 = New ADODB.Connection
db1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "mydatabase.mdb;Jet OLEDB:System Database=system.mdw;"
rs.Open "SELECT * FROM shoes", db1, adOpenKeyset, adLockPessimistic

With rs
If .RecordCount = 0 Then Exit Sub
.MoveFirst
Do While Not .EOF
If LCase(!brandname) = LCase(brandname) Then
frmSearch.List1.AddItem !brandname & " " & !name & " " & !Description & " " & !sellprice & " " & !Qty & " "
frmSearch.Label3.Caption = UCase(brandname)
frmSearch.iscar = True
frmSearch.Show
frmSearch.Width = 6225
frmSearch.Height = 9000

results = results + 1
.MoveNext
Else
.MoveNext
End If
Loop
End With
If results = 0 Or results < 1 Then
MsgBox "No Results", vbExclamation
End If
End Sub

I didn't include the little piece in the frmSearch which is pretty much a text box and a command button.

Just looking for the best route to organize this.

Thanks..

Ordering Columns In A List View

I know I can use the ascending and descending properties to order the first column in a list view, but how can I order the other columns as well?