How do I create a Browser Form

[Andy]

Does any one knows how to create a "browser form" that when finds the
specified document copies it to a specific folder and saves the new shortcut
to table field.

Tks in advance

 

[Tony Vrolyk]

Try the function here http://www.mvps.org/access/api/api0002.htm

You can use it like this...
Me.TextBox = fBrowseFolder "Title of Browse Box".

The field underlying Me.TextBox must accept Zero-Length string or you must
prevent them some other way.

Tony


** end code**

 

[Andy]

Tks Tony your suggestion is almost there.
The problem is that it only stores the folder path, and what I need is to
store a file path.
I'll try to make some changes to the code but suggestions are wellcome.

tks in advance
Andy

 

[Tony Vrolyk]

Dig around a little on the site and you will find
http://www.mvps.org/access/api/api0001.htm

Hope this works

 

[Andy]

Tks Tony
You are the MAN!

Your suggestion worked just as I needed!

Andy

 

[Tony Vrolyk]

Happy to help. Be sure to bookmark that site - I have gotten a lot of help
from it myself.