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