(RESOLVED) Dir list and File list

[Swatty]

Is there a tool I can use in Access to find directories and files on a machine or in the connected network.

It should be something like you have in VB.

I must develop it in Access for the moment.
Later it will be transfered to VB6 , so I could reuse things i make in access.

Any help app.

[darre1]

you can use the DriveListBox, DirListBox and FileListBox controls for this.

you can also use the Dir() function to search for files

[Hack]

Private Sub Form_Load() 
Drive1.Drive = "C:" 
End Sub
 
Private Sub Drive1_Change() 
Dir1.Path = Drive1.Drive 
End Sub
 
Private Sub Dir1_Change() 
File1.Path = Dir1.Path 
End Sub

[joltremari]

Private Sub Command77_Click()
 
If Dir("C:\My Documents\") <> "" Then
    MsgBox "WooHoo!"
Else
    MsgBox "Crap!"
End If
 
End Sub

[joltremari]

Same for a file

Private Sub Command77_Click()
If Dir("C:\My Documents\spreadsheet.xls") <> "" Then
 
    MsgBox "Yep!"
Else
    MsgBox "Nope!"
End If
 
End Sub

JO

[darre1]

Originally posted by joltremari

Private Sub Command77_Click()
 
If Dir("C:\My Documents\") <> "" Then
    MsgBox "WooHoo!"
Else
    MsgBox "Crap!"
End If
 
End Sub

straight from MSDN

[Swatty]

Can't find them in my toolbox.

Where are they located in access ???

[joltremari]

Where are what located?

[Swatty]

Where are what located?

The tools to let the user choose a file trough a drivelist and a filelist. But in Access

[Swatty]

Found something that is available in the Northwind.mdb

Used this works fine.

Everyone who even has tried to help me THANKS.