Uploading file name from windows file system

[lcky]

Hi

I am using Microsoft Access 2003 to build a form. It have data source from a single table. I have a text field on this form, where I input file name eg abc.jpg.
This field hold the name of graphic file in the file system folder. eg Photo

At present I have to type in file name manually. Is there any way I can add button, which on click open file system and go straight into my Photo folder, and then I select the require photo.

Please could you help, how do I go acheiving this.

many thank

 

[mp9]

Search Access VBA help for FileSystemObject

 

[PHV]

In ac2003, why not simply play with the FileDialog object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886