A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Please Help???!!! Word Documents In Access



 
 
Thread Tools Display Modes
  #1  
Old August 31st, 2005, 09:41 AM
A. Smart
external usenet poster
 
Posts: n/a
Default Please Help???!!! Word Documents In Access

I have a database in which each individual record is linked to a Word
document. In the report I would like to see contents of the document along
with its various other fields but I am only getting the FIRST PAGE of the
document.

I am really struglling with this one help would be muchly appreciated!!!!!

  #2  
Old August 31st, 2005, 12:37 PM
SA
external usenet poster
 
Posts: n/a
Default

A:

Access OLE controls will only show the first page of the document in the
container. There is no work around. A couple possible options:

1.) If you have only a little Access data that goes along with the Word doc,
then create a mail merge template from the Word doc and link to an pull in
the Access data in Word. That way you can format and lay everything out the
way you want it to.

2.) Print your Word docs to a PDF file and either a.) The print the Access
report to a PDF file and merge the two or b.) If you have adobe acrobat and
need to display all this in Access you can create a form, add the Acrobat
Active X control to the form and load the PDF file into the form and you can
navigate all the pages (although it might not print it all).

If option 2.a is what you'd like to accomplish take a look at our PDF and
Mail Library for Access, PDF Pro Plus edition where, if you have a PDF
driver, you can via VBA, automatically output the report, word doc and
combine the whole thing into one document.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"A. Smart" wrote in message
...
I have a database in which each individual record is linked to a Word
document. In the report I would like to see contents of the document along
with its various other fields but I am only getting the FIRST PAGE of the
document.

I am really struglling with this one help would be muchly appreciated!!!!!



  #3  
Old September 1st, 2005, 12:45 PM
A. Smart
external usenet poster
 
Posts: n/a
Default

Having trouble printing the Word Docs to PDF file. Can u explain how?


"SA" wrote:

A:

Access OLE controls will only show the first page of the document in the
container. There is no work around. A couple possible options:

1.) If you have only a little Access data that goes along with the Word doc,
then create a mail merge template from the Word doc and link to an pull in
the Access data in Word. That way you can format and lay everything out the
way you want it to.

2.) Print your Word docs to a PDF file and either a.) The print the Access
report to a PDF file and merge the two or b.) If you have adobe acrobat and
need to display all this in Access you can create a form, add the Acrobat
Active X control to the form and load the PDF file into the form and you can
navigate all the pages (although it might not print it all).

If option 2.a is what you'd like to accomplish take a look at our PDF and
Mail Library for Access, PDF Pro Plus edition where, if you have a PDF
driver, you can via VBA, automatically output the report, word doc and
combine the whole thing into one document.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"A. Smart" wrote in message
...
I have a database in which each individual record is linked to a Word
document. In the report I would like to see contents of the document along
with its various other fields but I am only getting the FIRST PAGE of the
document.

I am really struglling with this one help would be muchly appreciated!!!!!




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word2000 letterhead merge BAW Mailmerge 3 June 25th, 2005 01:17 PM
Why is a French Spellchecker a "required" update for English speak French Spellcheck Required? General Discussion 23 April 26th, 2005 01:17 AM
How do I keep two words together? LAD General Discussion 2 April 15th, 2005 12:25 AM
word xp crashes after macros are recorded kharris0405 General Discussion 3 January 11th, 2005 10:50 PM
WORD XP mail-merge FAILS using ACCESS query SueMackay Running & Setting Up Queries 4 November 29th, 2004 04:11 PM


All times are GMT +1. The time now is 09:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.