How do I browse for a filename and path?

[Stapes]

Hi

I am creating a database where the user needs to view photos linked to
each record.
I want to add a browse button somewhere to find the path these will be
stored on, and another to browse to the actual file and store the
filename.
How do I do this, using Access 2003?

Stapes

 

[Daniel Pineault]

The MVPS website has an API for exactly this. Take a look at

http://www.mvps.org/access/api/api0001.htm

From there you can get filename or directory/paths. Do not use ActiveX
dialogs as they will cause versioning issue.

 

[Arvin Meyer [MVP]]

Here what you need:

http://www.mvps.org/access/api/api0001.htm

 

[Stapes]

Here what you need:

http://www.mvps.org/access/api/api0001.htm
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com








- Show quoted text -

Thanks - that works a treat