File and Folder Browsing

[Craig]

Is there any built in objects or forms to allow a user to browse the file
system on their local PC?

ASP.NET has one and I would like something similar.

Thanks

 

[Allen Browne]

To open the Windows File Open/Save dialog, use this code:
http://www.mvps.org/access/api/api0001.htm

To browse for a folder:
http://www.mvps.org/access/api/api0002.htm

Access 2002 and 2003 have a File Dialog object, but it's better to use the
code above. FileDialog:
- does not work with older versions;
- requires an extra libaray (Office);
- does not work with MDE/runtime;
- does not work at all for Save As (even though it appears to offer that
choice).