Hyperlinking Word documents

[Rod C]

First, does anyone know where I can get the “Insert Hyperlink” button picture?

Second, I have a continuous subform, multiple records associated with a main record, to enter hyperlinks to associated Word documents.

Rather than have the data entry person click on the “Insert Hyperlink” button in the toolbar I want to use a button on my form that will run the code “DoCmd.RunCommand acCmdInsertHyperlink” to run the “Edit Hyperlink” utility.

The problem is that when you click on the button the focus leaves the record and the function errors. Any ideas on capturing the record number or something like that and then setting the focus back to that specific record before the function runs?

Other strategies also welcome.

 

[doulostheou]

If I am understanding your question, it has a simple solution. Let's say the field in which the hyperlink is stored is named Link. Use the code below in the on click event of your button.

'Move focus to appropriate field
Link.SetFocus
'Run command from the menu
DoCmd.RunCommand acCmd.InsertHyperlink

As for a picture, I would just do a screen print, paste it in Paint, and then cut out the appropriate icon.