Linked word document won't open

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

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

"RichardCP" wrote:

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

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

Originally Posted by RichardCP

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

Hi Ken

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

Richard

"Ken Sheridan" wrote:

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

"RichardCP" wrote:

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

Hi Bob

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

Richard

"Bob Miller" wrote:


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
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


--
Bob Miller