Browse

[Chad]

I was wondering if there was a way to include a browse
button on an access form. If so how would you go about
doing this?


Example:
I want the user to be able to search for a specific file
by browsing.

Thanks for any help you can offer,
Chad

 

[Allen Browne]

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

In Access 2002 or 2003, it is possible to use the FileDialog object, but it
requires a reference to the Office library, does not work in an MDE or
runtime, and does not work at all for Save As, so the API call is the best
way to go.

 

[Chad]

Allen,
Thanks for the site, it helped a lot. One other thing I
need though along the same lines. Is there a way for a
user to browse and select a file, then have the address of
that file show up in a textbox? This may be able to be
done through the code yo ugave me but I am not sure.
Thanks again,
Chad

 

[Allen Browne]

You can copy the string from the Windows FileOpen dialog (in the mvps.org
link) into your text box.

Alternatively, you coul1d use a Hyperlink field instead of a text field.
That way you can
RunCommand acCmdInsertHyperlink
If you put that into a command button, be sure to SetFocus to the Hyperlink
field first.

If you are not familiar with hyperlink fields, see:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html