If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Linked word document won't open
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 |
#3
|
|||
|
|||
Try inserting the object as a link. This way you will see changes to the original also.
Quote:
|
#4
|
|||
|
|||
Linked word document won't open
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 |
#5
|
|||
|
|||
Linked word document won't open
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word should catalog misspelled words to study. | rndthought | General Discussion | 38 | January 23rd, 2008 11:53 PM |
Word 97 in Windows XP to maintain formatting | Charlie''s Word VBA questions | General Discussion | 21 | October 24th, 2005 09:49 PM |
Templates | gman | Page Layout | 17 | April 22nd, 2005 06:35 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |