How do I browse for a filename and path?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stapes - 30 Nov 2007 13:56 GMT

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

Reply to this Message

Daniel Pineault - 30 Nov 2007 14:08 GMT

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.

Signature

Hope this helps,

Daniel Pineault

> Hi
>
[quoted text clipped - 6 lines]
>
> Stapes

Reply to this Message

Arvin Meyer [MVP] - 30 Nov 2007 14:10 GMT

Here what you need:

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

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hi
>
[quoted text clipped - 6 lines]
>
> Stapes

Reply to this Message

Stapes - 30 Nov 2007 16:29 GMT

> Here what you need:
>
[quoted text clipped - 14 lines]
>
> - Show quoted text -

Thanks - that works a treat

Reply to this Message