Is there an Access control that behaves like a standard File Browser dialog, like when you want to upload a document to an email etc.?

I have a field in my database which holds absolute paths to documents, and I'll be using a hyperlink to display the data, so people can just click on the link to open the file in its native application. But I'd also like for people to be able to be able to populate the field by browsing to the document on the network and after selecting it, its path gets stored in the DB.

Is there such a control available? Maybe ActiveX? This is an Access 2000 application.

Thanks.

Aaron

There should be an file browser activex that came with Access 2000. You will just have to make sure that it is registered on your development machine, and on each user's machine.
Alternatively, you can script one, and associate the file froma drop down list. This will work without activex.

mmcdonal

See the "Access Cookbook, 2nd Ed." by O'Reilly, ISBN: 0596006780 page 333, 7.8 Fill a list box with a list of files. This shows you how to make a file browser form, and you can capture the filename and path selected.

HTH


mmcdonal

I would recommend using the windows standard commom dialog.

chech out how here

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

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com