Search results for query: *

Thanks JbinQLD & PHV Now it's works I would like. I added to ListBox also DblClick function so I can open these files. So final code to see file with value using code of Allen Brown: Purpose: to see if in directory are files with same value from field [Numero]. It’s a possibility to open each...

Hi, Sorry stupid question but where I put this 'strTrimmed' code to have result in ListBox?

Thanks, Thanks, Thanks It's works. Now, 1. I add .RowSource = "" to clean ListBox for evere record. So when I pass to next record I have new list of files. Private Sub Form_Current() Dim cartella, Categoria As Variant Dim strPath As String, strFileSpec As String cartella =...

Hi, After the night error is changed mind and is changed. Now it's error '94' Invalid use of Null. It's producing line: Call ListFiles(strPath, strFileSpec, Me.lstFileList) Debug is showing that: strPath = "fullpath" (OK) strFileSpec = "*0022038*.doc" Me.lstFileList = Null --code-- Private...

Hi, Thanks JBinQLD. 1. When I used Call ListFiles(MyPath,"*" & Format(Me!Numero, "0000000") & "*.doc") I don't get list in listbox at all. When I used Call ListFiles(MyPath,"*" & Format(Me!Numero, "0000000") & "*.doc", Me.lstFileList) I get error "Run-time error '13': Type mismatch. 2. In the...

Hi, I’m looking for some piece of code to list files in directory but with some filter. I must verify if I have simile files in directory. I tried to use the code from http://allenbrowne.com/ser-59.html but it’s not working like I would like. I tried get in “listbox” (lstFileList) files contain...