[belajar-access] Gimana Cara mencari File pakai VBA

[andikprabowo]

Mohon penjelasan dong, untuk list mencari file?

ini ada contoh dari help VBA
=============================

FileSearch Object
-----------------

  FileSearch
  ----------  
       Multiple objects
       ----------------


Represents the functionality of the Open dialog box (File menu).


Using the FileSearch Object
===========================
Use the FileSearch property to return the FileSearch object. The 
following example searches for files and displays the number of 
files found and the name of each file.

With Application.FileSearch
    If .Execute() > 0 Then
        MsgBox "There were " & .FoundFiles.Count & _
            " file(s) found."
        For i = 1 To .FoundFiles.Count
            MsgBox .FoundFiles(i)
        Next i
    Else
        MsgBox "There were no files found."
    End If
End With


thanks