command button which chooses or opens specific file

[ion97]

I have a database with information on articles (author, date published etc) stored in my hard disc or/and CD-ROM's.
The articles are in various formats (pdf, html etc)

Is it possible to have:

1) a command button on my data entry form which will enable the user to choose the path (such as c:\blabla\filename.pdf) to the file stored?

2) a command button on the main form which will open the specified file when the user clicks on it (simillar to what the runApp command does but a command button which will open a file of any kind)?

 

[jimbrooking]

Have a peek at
http://www.mvps.org/access/api/api0001.htm

Suitably tweaked, this ought to do what you want.

 

[ion97]

Ok, I got it!
the save as... dialog box opens correctly.

But how is the selected path transfered to the text box? (the text box "is hyperlink" property is set to yes"