File open

[Guest]

hi
I use
http://www.mvps.org/access/api/api0001.htm
Working fine
But how do i get the path into a tekstbox in my form?
Can't see it,
Alvin

 

[Douglas J. Steele]

Not sure exactly what you're asking for.

If you look at the 4 line example at the top of the page, strInputFileName
contains the complete path to the file you've selected.

Do you only want the path out of that? You can use:

Left$(strInputFileName, Len(strInputFileName) - Len(Dir$(strInputFileName)))

or you can use the InStrRev function to find the last \ in strInputFileName:

Left$(strInputFileName, InStrRev(strInputFileName, "\") - 1)

 

[Guest]

Thanks
its working

Alvin

Not sure exactly what you're asking for.

If you look at the 4 line example at the top of the page, strInputFileName
contains the complete path to the file you've selected.

Do you only want the path out of that? You can use:

Left$(strInputFileName, Len(strInputFileName) - Len(Dir$(strInputFileName)))

or you can use the InStrRev function to find the last \ in strInputFileName:

Left$(strInputFileName, InStrRev(strInputFileName, "\") - 1)