Retrieve date with file for listbox and sort

[akirekab]

I am using the following to retrieve a file and put in listbox. It is working fine.
I would like to build on it to include the datecreated of the file and be able to also sort with that date.

 Const iPath = "C:\patient\scans\Insurance\"
        Dim myInsFile As String
        Dim strPatientId As String
 
        myInsFile = Dir(iPath & strPatientID & "*.*")
 
        lstInsurance.Clear
 
        Do While Not myInsFile = vbNullString
 
             lstInsurance.AddItem myInsFile
             myInsFile = Dir
 
        Loop
 

Thank you for any help
Ken

[VijaySofist]

Hi!

I think you are trying to add the files to the ListBox by getting a FolderName(with path). If this is your criteria means you can use a FileListBox Control instead of a ListBox Control. It will display all the files from your folder path. You can also sort it in Ascending or Descending order.


With Regards
Vijay. R

[akirekab]

I am not sure how the filelistbox works.
But my objective is to retrieve a set of files with criteria of a number, and only that set of files. It may be one or a dozen files starting with nxxxxx, I would like the file name and date in the list box or file list box if thats possible and in descending order.Then the customer can double click and display the file.

I do not want all the files currently active showing.

I put a file list box in but it showed all current files of the program. Maybe you could give me an example of using the same type of code I have in here, but utilizing a file list box.

[Killer42]

You might want to try out the ListView control. It allows you to create entries with a number of attributes, which can be viewed as a list, icons and so on, much like Windows Explorer.

Another alternative would be to use a simple grid control, with columns for the pieces of information you're interested in such as name and date.

[akirekab]

Thnks Killer

First I would like to apologize, I had to leave state, and didnt get back to this till now.

One question on your comment, is the control you reference going to work in VB5 ?

Ken

[Killer42]

One question on your comment, is the control you reference going to work in VB5 ?

Um... to be honest, I have no idea.

If VB5 doesn't include the Listview control then you may have to track down a copy somewhere. Whether it will actually work, I don't know. But these controls are more or less useable with any language that can use ActiveX controls, aren't they? If someone else here knows more about this sort of compatibility, please let us know.