merging template with rtf

[kfschaefer]

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.

 

[Jean-Guy Marcil]

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.
--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[kfschaefer]

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

 

[Jean-Guy Marcil]

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:

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[kfschaefer]

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

 

[Jean-Guy Marcil]

kfschaefer was telling us:
kfschaefer nous racontait que :

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

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!

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[kfschaefer]

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.

 

[Jean-Guy Marcil]

kfschaefer was telling us:
kfschaefer nous racontait que :

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)

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


--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org