ListView Control to search a directory

[babyJebus]

I need a ListView control in Microsoft Access to search for an Excel file, and select a file to perform actions on such as importing it into the database.

Any of you guys know if this can be done, and if so how to do it.

 

[danvlas]

What's the problem in using a ListBox instead of ListView?
Populate it with Dir and AddItem and you have everything you need.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[ZmrAbdulla]

You can do it with listbox easily. There should be many examples here.

Here is an example with ListView.

Private Sub Form_Load()
    Dim sPath As String
    Dim sFile As String

    'Change this path as required
    sPath = "C:\Excel Files\"
    sFile = Dir(sPath, vbDirectory)

    With Me.ListView0
        .View = lvwReport
        .ListItems.Clear
        .ColumnHeaders.Clear
    End With

    With Me.ListView0.ColumnHeaders
        .Add , , "File Name", Me.ListView0.Width - 100, lvwColumnLeft
    End With

    Do While sFile <> ""
        If Right(sFile, 4) = ".xls" Then
            With Me.ListView0
                Dim itmx As ListItem
                Set itmx = ListView0.ListItems.Add(, , sFile)
            End With
        End If
        sFile = Dir
    Loop
End Sub

To get selected name from the list see faq702-6026.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.