(RESOLVED) Dir list and File list

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.

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

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

VB Code:

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

:D

VB Code:

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

:D

Same for a file:)

VB Code:

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

JO

Quote:

---

Originally posted by joltremari
:D

VB Code:

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

:D

---

straight from MSDN :eek:

Can't find them in my toolbox.

Where are they located in access ???

Where are what located?

Quote:

---

Where are what located?

---

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

Found something that is available in the Northwind.mdb

Used this works fine.

Everyone who even has tried to help me THANKS.