Locating Files on the Local Machine

[pparadis]

I'm working on an MS Access form. I want the user to be able to browse their machine for a file, select it, and then the vbcode will move it to a folder on a shared drive and save the location of the file in the db. I'm looking for a control that allows the user to find a file on their machine.

Thanks.

 

[FancyPrairie]

This thread thread705-370783 shows you a couple of ways to allow the user to browse to a file. You can use the Copy method to copy the file where you want.

object.CopyFile source, destination[, overwrite]