File Browse in a Form? (Access 2003)

[jthomas666]

Working on a tracking database for my own use. One of the things I want to do is to be able to enter a path/filename for a given Framemaker file, and to be able to open the file from the form.

Here's how I would like it to work:

When entering a new record, have a browse button next to the file field. Pressing that button opens a standard file open dialog box with a default location (for example, \\server\documents). From that point, I can navigate to the file, and selecting the file enters the pathname into the database field. The field displays the filename only (no path (this isn't an absolute requirement, it's just to keep a clean form)); the field is formatted as a hyperlink, so I can open the file directly from the form.

Thoughts or suggestions?

 

[Remou]

An Advanced Search in the Access fora for 'browse file' should return a number of records. Bear in mind that 2003 has features that are not available in 2000. As for hyperlinks, FollowHyperlink in a Dbl-Click event is less stressful than a hyperlink field.