File Browse Dialogue Box

[Guest]

I’m trying to make a pop-up/modular form that lets the user select a file to
import/export data within the database. The way I’m doing it now is having
the user right the full file path/name in an unbound control and having the
macro pull it from there, but this is rather inconvenient for the average
user. Any suggestions?

A-Mart

PS – I posted this question yesterday, but I can’t find it on the list

 

[Steve Schapel]

Alex,

If you have a fixed finite number of file path/name options that the
user will be needing to select from, you could put these in a table,
which could then be accessed via a combobox on your form.

Otherwise, if you are talking about a full function file browse dialog,
to select from within your computer's file system, you will need to use
VBA and base it on this:
http://www.mvps.org/access/api/api0001.htm