Linked word document won't open

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RichardCP - 14 Feb 2006 09:44 GMT

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

Reply to this Message

Ken Sheridan - 14 Feb 2006 18:33 GMT

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

> 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
[quoted text clipped - 5 lines]
>
> Richard

Reply to this Message

RichardCP - 15 Feb 2006 09:04 GMT

Hi Ken

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

Richard

> Richard:
>
[quoted text clipped - 27 lines]
> >
> > Richard

Reply to this Message

Bob Miller - 14 Feb 2006 19:56 GMT

Try inserting the object as a link. This way you will see changes to
the original also.
RichardCP Wrote:

> I have linked a word document to a form in my database. However, when
> I
[quoted text clipped - 8 lines]
>
> Richard

Signature

Bob Miller

Reply to this Message

RichardCP - 15 Feb 2006 09:08 GMT

Hi Bob

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

Richard

> Try inserting the object as a link. This way you will see changes to
> the original also.
[quoted text clipped - 11 lines]
> >
> > Richard

Reply to this Message