problem with linking to a word document using an OLE object

  • Thread starter Thread starter Janette
  • Start date Start date
J

Janette

Hi,

I need to link to a word document in a report so that when the word document
is updated the report text is updated. I have been successful in doing this,
but the word document is more than one page, but the linked object only
shows to the end of the first page. Can anyone suggest a how to be able to
see the whole document from 1 linked object?

Thanks
Janette
 
Hi Janette,

Thanks for your posting!

From your descriptions, I understood you would like to know how to display
the second and follow-up page of a word document in Access pages. If I have
misunderstood your concern, please feel free to point it out.

Based on my knowledge, OLE object frames will only display the first page
and you have to find another way to do this if you want to see the whole
document. For example, use html pages instead of word document.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Thanks Michael for your reply.

Essentially what I am trying to do is like a mail merge, but from Access. I
have an Access report that based on the parameters from a form, generates
reports (which are essentially letters). All the header section contains the
results of a SQL query, based on the parameters from the form, then the rest
of the report is the content of a word document which is the same for all
reports. The problem is that the administrators of the system want to be
able to change the content of the word document from time to time. As the
word document is multiple pages, embedding it as an OLE linked file is a
problem because it only displays the first page. I have tried your
suggestion of making the OLE linked file an html file, but instead it links
it as an icon.

Any further suggestions would be helpful.

Regards
Janette
 
Hi Janette,

Thanks for your question.

As I have said here is the limitation about OLE object. I understood this
behavior is annoying, but please understand it is by design. Luckily, you
may take following two ways as workaround

1. separate the multiple pages into muptiple files with one page per file.

2. double click the OLE Bound Object link, it will open Word and show all
the pages.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top