I'm still not sure what you want then. You can browse inside a folder with:
http://www.mvps.org/access/api/api0001.htm

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
> I'm still not sure what you want then. You can browse inside a folder with:
>
[quoted text clipped - 12 lines]
> >>
> >>http://www.mvps.org/access/api/api0002.htm
Arvin,
OK, a bit more detail.
Imagine you are sitting in front of the computer and Access is
displaying a form on screen. One of the Text fields is displaying a
pathname to a folder, say "C:\My Documents\Access\Accounts\" for
example (actually it will normally be a path to a folder on a Server
PC).
Now I decide I want to delete one of the files in that folder so I
minimize Access (or click on the Show Desktop icon on the task bar
which does the same thing), I click the Windows Start button, then My
Computer, then double click C:\, then double click the My Documents
folder, then double click the Access folder, then double click the
Accounts folder which then shows me the contents of the Accounts
folder. Now I can delete the file (or whatever). With a Network system
it would be even more long winded. OK, the user can set up short cuts
to the 'root' folder to speedup the process a bit but there are
hundreds of subsidiary folders involved here.
The point is that I already know the pathname of the required folder
(it's stored in a Text box on the form) so I would like a button on
the same form which, when clicked, will, in effect perform all the
actions shown above, and open a window on the required folder.
I suppose another alternative (which may be acceptable to my client)
is to run Windows Explorer using the Shell command. Not sure how to do
that either as I would also need to pass the stored pathname to it
somehow.
Any ideas?
Peter Hibbs.
>I'm still not sure what you want then. You can browse inside a folder with:
>
>http://www.mvps.org/access/api/api0001.htm
Arvin Meyer [MVP] - 10 May 2008 13:38 GMT
One last question. I understand that you know the path to the folder. Do you
know the filename as well? or will the user be required to just browse to
find it?

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
> Arvin,
>
[quoted text clipped - 35 lines]
>>
>>http://www.mvps.org/access/api/api0001.htm
Peter Hibbs - 10 May 2008 15:43 GMT
No, the user will want to select any file/s from the folder and then
move it, copy it, delete it, rename it, etc, etc. I had considered
giving them the option to just copy or delete a file with some VBA
code but they may also want to move multiple files from the folder in
question to another folder, create a new sub-folder, delete the old
folder and so on. Basically they need all the facilities of a standard
OS Window, all I need to do is give them quick access to the folder
that the database has currently selected so that they don't need to go
through the hassle of finding the relevant folder each time.
Apparently they do this quite a lot, the folders hold copies of
document files (mainly Word but could be PDF and XLS) which they have
created via the database and there is a sub-folder for each client
with sub-sub-folders for various categories of document such as
General Insurance, Motor Insurance, Life Insurance, Mortgage, etc,
etc.
Peter Hibbs.
>One last question. I understand that you know the path to the folder. Do you
>know the filename as well? or will the user be required to just browse to
>find it?