Sheils
asked on
How to display entire word document in MSAccess OLE container
Hi Experts,
I have inserted a word document as a link inside an OLE container of an MSAccess form. It works find and I can double click to open the document in words and edit it.
However, I can only display the first page in the OLE container. Is there a way to scroll the entire document from within the OLE container?
Regards
SB
And I send my heart felt sympathy to all out New Zealand colleagues
I have inserted a word document as a link inside an OLE container of an MSAccess form. It works find and I can double click to open the document in words and edit it.
However, I can only display the first page in the OLE container. Is there a way to scroll the entire document from within the OLE container?
Regards
SB
And I send my heart felt sympathy to all out New Zealand colleagues
I think it might be a better idea to just store a hyperlink to the document, and open it directly by clicking on the link.
ASKER
Hi Helen
That would surely be easier. However, it would just be more practical to display the document in Access. Is it possible
That would surely be easier. However, it would just be more practical to display the document in Access. Is it possible
<I can double click to open the document in words and edit it.
However, I can only display the first page in the OLE container. Is there a way to scroll the entire document from within the OLE container?>
This works fine for me.
If I double click the OLE field/control, I can scroll trough an entire multipage Word Doc.
(See the attached screenshot. It clearly displays the Page break and even the ruler is still visible...)
What version of Office are you using?
If you are using Access 2007 or newer you may want to consider the new Attachment Datatype.
Remember OLE has never been "Perfect".
It was simply meant as a way to link info across applications.
Displaying Multipage Documents, Special Formatting, Full editing capabilities, ...were never the goal.
(lest we forget all the "OLE Server" issues we see here...)
;-)
JeffCoachman
However, I can only display the first page in the OLE container. Is there a way to scroll the entire document from within the OLE container?>
This works fine for me.
If I double click the OLE field/control, I can scroll trough an entire multipage Word Doc.
(See the attached screenshot. It clearly displays the Page break and even the ruler is still visible...)
What version of Office are you using?
If you are using Access 2007 or newer you may want to consider the new Attachment Datatype.
Remember OLE has never been "Perfect".
It was simply meant as a way to link info across applications.
Displaying Multipage Documents, Special Formatting, Full editing capabilities, ...were never the goal.
(lest we forget all the "OLE Server" issues we see here...)
;-)
JeffCoachman
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Jeff
Good to catch up mate.
I am using Access 2010. Bit of a learning curve.
Mine does not show the rule and page break like your. Is there some settings or code that I am missing.
The attachment looks interesting but noting that the user might add un-resized photos to the document we might end up with large files that will slow the database or even exceed the 2GB limit. So I'd rather stay away from it if I have a choice.
Cheers
SB
Good to catch up mate.
I am using Access 2010. Bit of a learning curve.
Mine does not show the rule and page break like your. Is there some settings or code that I am missing.
The attachment looks interesting but noting that the user might add un-resized photos to the document we might end up with large files that will slow the database or even exceed the 2GB limit. So I'd rather stay away from it if I have a choice.
Cheers
SB
SB
My test was in 2007.
So, to be sure, I will test this in 2010 when I get back to work on Friday...
Jeff
My test was in 2007.
So, to be sure, I will test this in 2010 when I get back to work on Friday...
Jeff
Well, try this out! I am not that expert in access (I haven't used access for very long time)
Any ways try this out!
http://support.microsoft.c om/kb/1478 04
Any ways try this out!
http://support.microsoft.c
You can also check out the existing Experts exchange Solution
http://www.experts-exchang e.com/Prog ramming/La nguages/Vi sual_Basic /Q_2015076 6.html
http://www.experts-exchang
ASKER
Did not work with mine. But there was no better answer