Linked word document won't open

[Guest]

I have linked a word document to a form in my database. However, when I
click on it to open it, nothing happens. It will open, however, when I am in
design view. How can I make it open in form view? Do I need to create a
macro? If so, there doesn't appear to be an "OpenWordDocument" choice
available in the drop-down menu of the macro builder.

Grateful for any help or advice. Many thanks.

Richard

 

[Guest]

Richard:

An easy way is to put the full path to the Word file in a Hyperlink field in
a table. You can then have different paths in different rows in the table
and in a form bound to the table just click on the relevant one.

If you want to open the file from an unbound form you can put the path in an
unbound text box on the form and in the text box's DblClick event procedure
for instance, or the Click event procedure of a separate button follow the
hyperlink with the following code:

FollowHyperlink Me.txtPath

where txtPath is the name of the unbound text box.

It can also be done in code by 'automation' or by using the VBA Shell
function or by calling the Windows API ShellExecute function, but I think the
hyperlink route will probably suffice in your case.

Ken Sheridan
Stafford, England

 

[Guest]

Hi Ken

Many thanks. This is all too advanced for me but I'll try to work out how
to do it.

Richard

 

[Guest]

Hi Bob

The word document is already set up as a link. Do I need to change the way
I have done it?

Richard