Want to get a files path from a browse button / dialog box

[GriffG]

I want to open a form that is used for importing a csv file into the database, I need to be able to find the files path.

I am wanting to have a browse button on the form that opens a dialog that you can you to find the file. then I want to store the path and the path+filename into two Variables.

this is so that I can use the same dialog for the import and the export of the information. the path for exporting to a csv and the path+filename for importing from a csv

 

[PHV]

Depending of your version of Office you may consider the FileDialog object.

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

 

[GriffG]

I am using Access 2003 but I am also wanting to be able to do this in Access 2000. will the FileDialog object Work in both of those?

 

[RoyVidar]

I think the filedialog object is available starting with the 2002 version, so I'm afraid the answer is no.

Try Call the standard Windows File Open/Save dialog box.

Roy-Vidar