 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / October 2006merging template with rtf
is there a proces that when a rtf files is created from an Access Report to specify which word Document (in this case a template) the rtf is to be included in.  SignatureKaren kfschaefer was telling us: kfschaefer nous racontait que : > is there a proces that when a rtf files is created from an Access > Report to specify which word Document (in this case a template) the > rtf is to be included in. The best thing to do is create a document in Access directly from the intended Word template, populate it and then save it as rtf if the doc format is not wanted. If for some reason this cannot be done, you can create an Access Sub that will take the aforementioned rtf file, open it, create a document based on the intended Word template, transfer the text form the rtf file to the document, close the rtf document, wrap up the Word document and save it. SignatureSalut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE@CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org Jean-Guy, Thanks for the suggestion, however, When I tried to incorp. the word template(which is full page drawing template) I run into an issue that when I generate the report i get a size limitation issue. also, where would I place this image in Access. I tried in the Rpt Header and In the Page Header - niether would allow me to generate the report and If I export or publish to Word - would I lose the template formatting - just like loosing the line formats when I open the doc in Word. Thanks SignatureKaren > kfschaefer was telling us: > kfschaefer nous racontait que : [quoted text clipped - 11 lines] > the intended Word template, transfer the text form the rtf file to the > document, close the rtf document, wrap up the Word document and save it. kfschaefer was telling us: kfschaefer nous racontait que : > Jean-Guy, > > Thanks for the suggestion, however, When I tried to incorp. the word > template(which is full page drawing template) I run into an issue What is a "full page drawing template"? Word is a word processor, not an image manager... > that when I generate the report i get a size limitation issue. also, > where would I place this image in Access. I tried in the Rpt Header What image? Why would you want to place an image in Access? Are dealing with a picture database? > and In the Page Header - niether would allow me to generate the > report and If I export or publish to Word - would I lose the template > formatting - just like loosing the line formats when I open the doc > in Word. You can certainly export data from Access directly into Word. If that is to involved, than generate the RTF report as you have been doing, and then try my second suggestion: >> If for some reason this cannot be done, you can create an Access Sub >> that will take the aforementioned rtf file, open it, create a >> document based on the intended Word template, transfer the text form >> the rtf file to the document, close the rtf document, wrap up the >> Word document and save it. SignatureSalut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE@CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org Jean_Guy the picture I am speaking of is a Word Template that contains the background of a Cad/drafting Drawing specifics like drawing number, name, item, and etc. This contains numerous boxes that when displayed look like a legend of a Blue print if this helps. I need to create a method to incorporate the specific Access Report into the center of this template and the background must be repeatable on each page of the report. Whether I incorporate it in Access or In word. My current method which is clumsy is to export the Access report into a rtf into Word then thru a macro, copy the original template and place it into the header of the rtf, then forcing the user to File Saveas. I was hoping someone could offer a better solution - possibly a way to assign the Template to the rtf file generated by Access or a way to shrink and grow the template(ie. piciture) into the Access Report without creating a File over the margin limitations. Thanks, I hope this is more clearer in describing my current situation. Karen SignatureKaren > kfschaefer was telling us: > kfschaefer nous racontait que : [quoted text clipped - 29 lines] > >> the rtf file to the document, close the rtf document, wrap up the > >> Word document and save it. kfschaefer was telling us: kfschaefer nous racontait que : > Jean_Guy > [quoted text clipped - 4 lines] > method to incorporate the specific Access Report into the center of > this template and the background must be repeatable on each page of You want an image of the Access report in the middle of a age in Word? > the report. Whether I incorporate it in Access or In word. My > current method which is clumsy is to export the Access report into a > rtf into Word then thru a macro, copy the original template and place > it into the header of the rtf, then forcing the user to File Saveas. ??? See below. > I was hoping someone could offer a better solution - possibly a way > to assign the Template to the rtf file generated by Access or a way > to shrink and grow the template(ie. piciture) into the Access Report A template cannot be shrunk, unless you remove stuff from it. > without creating a File over the margin limitations. I think we are having a "terminology" problem. You cannot copy a Word Template and then paste it in the Word document header. A template in Word is a special document that has the extension *.dot. This template is a model from which documents (*.doc) will be created. These templates can have custom toolbars, AutoText entries, macros, etc This means that all documents created form this template will have access to all that. What is a template for you? So until this is clarified, it is difficult to offer more help, unless someone else has a good idea what you mean.... then by all means, jump in! SignatureSalut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE@CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org Jean-guy, Yes I do know the differences between .doc and .dot and my file is .dot - My thought was that I could use the template as the basis for my genereated .doc document. Except since Access will generate a new rtf on export in and open Wod I was wondering if there is any code I can use to make sure that when I create the rtf file in Access I can tell it to use the .dot template each time it is run and also force the user to save the new rtf file as a Word document.(.d0c) My Template is just that the Template for the basis of my newly generated rtf file from Access. My Template contains the picture in the header that I want to be displayed on each page of my newly created .rtf - soon to be saved .doc files. SignatureKaren > kfschaefer was telling us: > kfschaefer nous racontait que : [quoted text clipped - 38 lines] > So until this is clarified, it is difficult to offer more help, unless > someone else has a good idea what you mean.... then by all means, jump in! kfschaefer was telling us: kfschaefer nous racontait que : > Jean-guy, > [quoted text clipped - 5 lines] > tell it to use the .dot template each time it is run and also force > the user to save the new rtf file as a Word document.(.d0c) What code do you use to explicitly produce the rtf? If you are using Access's native report making tools, I do not think you can port the data directly in a dot to create a doc. But to be certain you should ask about this in an Access group. But, I am sure you can use your data in Access to create a doc based on a dot. Here is a simple example to insert Access data in a Word document from Word VBA: http://word.mvps.org/faqs/interdev/getdatafromdb.htm But normally, when sending data from a database to a word document, we are performing a mail merge (either a letter type - One document per record - or a Catalogue type (Can't remember the new name for this) - each record appended to the previous one in a continuous fashion. Form more on this: http://homepage.swissonline.ch/cindymeister/MergFram.htm SignatureSalut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE@CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.