Adding a button to retrieve a link to a document

[Guest]

I am trying to create a form where the user can enter the location of a
number of files that are associated with a project (estimate, business spec,
development spec, project plan, etc.)

To store this information, I am using a hyperlink to the the files. When I
set the control on the form to unbound, the hyperlink option is greyed out
when you right click.

So, I thought I would add a button, for the user to click for add ing the
hyperlink. what i can't find is what command I use when the user presses
this button, so that the Edit hyperlink dialog box will be displayed and how
I load the file they select as the hyperlink in the original control.

Any help would be appreciated.

 

[IanOxon via AccessMonster.com]

Instead of adding a Hyperlink Field you could capture the Absolute FilePath
of the files in a memo field. This is more flexible in the long run and has
a smaller overhead. If you add a Comman Button to your form & you can set
the Hyperlink Property of that Control in code to open the file. See the
coding in:
http://www.accessmonster.com/Uwe/Fo...k-hyperlink-to-a-set-of-tiff#5d375a93a5c33uwe


The other issue is getting the FilePath when you create or edit a record.
You can use another Command Button to launch the OpenFile CommonDialogue box
and update the memo field with the results. The VB6 API way to do this is
described here: http://w.ex-designz.net/apidetail.asp?api_id=122. The other
way is to include and ActiveX CommonDialogue Control to your form. A
description of how to use this control can be found here:
http://www.nsbasic.com/ce/info/technotes/TN08.htm.


Regards


Ian