Connecting Tech Pros Worldwide Forums | Help | Site Map

List Directory- Include Hiden files - Access !?

Newbie
 
Join Date: May 2007
Location: Kosova
Posts: 6
#1: Nov 17 '08
Hi,
I am using this code in access form to list everything in directory but it did`not show hidden or system files.
how works this code to list all files include hidden or system files.?
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()
  2. Dim LoadFiles   As String
  3. Dim strFill     As String
  4.  
  5. LoadFiles = dir$("c:\*.*")
  6. Do While LoadFiles > ""
  7. strFill = strFill & LoadFiles & ";" 
  8. LoadFiles = dir$
  9. Loop
  10. lstFiles.RowSource = strFill
  11.  
  12. End Sub
Thank you

ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,218
#2: Nov 19 '08

re: List Directory- Include Hiden files - Access !?


Try:
Expand|Select|Wrap|Line Numbers
  1. Dim LoadFiles As String
  2. Dim strFill As String
  3.  
  4. LoadFiles = Dir$("c:\*.*", vbbHidden Or vbSystem)
  5.  
  6. Do While LoadFiles <> ""
  7.   strFill = strFill & LoadFiles & ";"
  8.   LoadFiles = Dir$
  9. Loop
  10.  
  11. lstFiles.RowSource = strFill
Newbie
 
Join Date: May 2007
Location: Kosova
Posts: 6
#3: Nov 20 '08

re: List Directory- Include Hiden files - Access !?


Quote:

Originally Posted by ADezii

Try:

Expand|Select|Wrap|Line Numbers
  1. Dim LoadFiles As String
  2. Dim strFill As String
  3.  
  4. LoadFiles = Dir$("c:\*.*", vbHidden Or vbSystem)
  5.  
  6. Do While LoadFiles <> ""
  7.   strFill = strFill & LoadFiles & ";"
  8.   LoadFiles = Dir$
  9. Loop
  10.  
  11. lstFiles.RowSource = strFill


It Works Many thanks ......
ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,218
#4: Nov 20 '08

re: List Directory- Include Hiden files - Access !?


Quote:

Originally Posted by ragazzo

It Works Many thanks ......

Glad it works for you.
Reply