Do you ever wonder how to prompt for a file or folder from within an Access database?
I'm going to show you how to select a file or folder using the FileDialog object that comes with Microsoft Office. This is available from Microsoft Access of course. I also have some VBA code here you can download to help you do this.
~~ Links ~~
Select a File or Folder using the FileDialog Object
Bytes free forum to get Access help
Access and Excel Consulting
Adrian, AKA NeoPa