Logo and Page border Not visible

[Raj]

Hi All,

I am using MS Access 2003 version.I have Logo and Page border (displayed
using Code) [Placed inside Report Header]and other fields taken from DB.The
problem is while preview,I am able to see all this,but once I create the Word
document either by Publish or by Export options.The logo and page borders
become invisible.Please help me on this,its very urgent.

thanks and regards

Raj

 

[Rob Parker]

Hi Raj,

I guess that your logo is a picture/image, and the page border is probably a
box. If you export an Access report to Word, you lose all graphic elements
such as picture/images, and lines/boxes. The only formats in which these
elements are retained are by printing to a .pdf file, or exporting to a
Snapshot format file.

HTH

Rob

 

[Raj]

Hi Rob Parker,

Thanks a lot for your answer. Even though I give inside Report Header ,its
still the same, And as you told I can see the Logo and border when I take a
Snapshot output.

My concern is after taking the output still there needs human intervention
to edit the content in some cases , so that puts me to same situation where
I need all these graphics and still I should be able to edit the document as
well, :-( is there any way for this ?

thanks for your help

Raj

Hi Raj,

I guess that your logo is a picture/image, and the page border is probably a
box. If you export an Access report to Word, you lose all graphic elements
such as picture/images, and lines/boxes. The only formats in which these
elements are retained are by printing to a .pdf file, or exporting to a
Snapshot format file.

HTH

Rob

Hi All,

I am using MS Access 2003 version.I have Logo and Page border (displayed
using Code) [Placed inside Report Header]and other fields taken from
DB.The
problem is while preview,I am able to see all this,but once I create the
Word
document either by Publish or by Export options.The logo and page borders
become invisible.Please help me on this,its very urgent.

thanks and regards

Raj

 

[Evi]

I don't know how to do this, but rather than the usual sort of simple
export, perhaps it would be possible to export using a specific Word
template which would have the logo and border in it.
Any coding suggestions, anyone?
Evi

Hi Rob Parker,

Thanks a lot for your answer. Even though I give inside Report Header ,its
still the same, And as you told I can see the Logo and border when I take a
Snapshot output.

My concern is after taking the output still there needs human intervention
to edit the content in some cases , so that puts me to same situation where
I need all these graphics and still I should be able to edit the document as
well, :-( is there any way for this ?

thanks for your help

Raj

Hi Raj,

I guess that your logo is a picture/image, and the page border is probably a
box. If you export an Access report to Word, you lose all graphic elements
such as picture/images, and lines/boxes. The only formats in which these
elements are retained are by printing to a .pdf file, or exporting to a
Snapshot format file.

HTH

Rob

Hi All,

I am using MS Access 2003 version.I have Logo and Page border (displayed
using Code) [Placed inside Report Header]and other fields taken from
DB.The
problem is while preview,I am able to see all this,but once I create the
Word
document either by Publish or by Export options.The logo and page borders
become invisible.Please help me on this,its very urgent.

thanks and regards

Raj

 

[Rob Parker]

Hi again Raj, and Evi

I believe that Evi is confirming that a normal export to Word will not
include any graphic elements.

If you must export to Word, you'll need to do it with considerably more
complicated code, almost certainly involving pushing data from your query
(or table - the RecordSource of your report) into a Word template. The site
that I know of that provides several examples of this is Helen Feddema's
Access Archon site, at http://www.helenfeddema.com/access.htm. The
downloadable zip files for her Access Archon columns 55 and 65 are promising
starting points. Perhaps some late ones also.

There's probably lots of other sites out there with examples/code for Office
Automation tasks (including, almost certainly, something in the MSDN area)
but Helen's is one that I know of - and her code works.

HTH,

Rob

I don't know how to do this, but rather than the usual sort of simple
export, perhaps it would be possible to export using a specific Word
template which would have the logo and border in it.
Any coding suggestions, anyone?
Evi

Hi Rob Parker,

Thanks a lot for your answer. Even though I give inside Report Header
,its
still the same, And as you told I can see the Logo and border when I take a
Snapshot output.

My concern is after taking the output still there needs human
intervention
to edit the content in some cases , so that puts me to same situation where
I need all these graphics and still I should be able to edit the document as
well, :-( is there any way for this ?

thanks for your help

Raj

Hi Raj,

I guess that your logo is a picture/image, and the page border is probably a
box. If you export an Access report to Word, you lose all graphic elements
such as picture/images, and lines/boxes. The only formats in which these
elements are retained are by printing to a .pdf file, or exporting to a
Snapshot format file.

HTH

Rob

Hi All,

I am using MS Access 2003 version.I have Logo and Page border (displayed
using Code) [Placed inside Report Header]and other fields taken from
DB.The
problem is while preview,I am able to see all this,but once I create the
Word
document either by Publish or by Export options.The logo and page borders
become invisible.Please help me on this,its very urgent.

thanks and regards

Raj

 

[Rob Parker]

Hi Raj,

My concern is that you say "My concern is after taking the output still
there needs human intervention
to edit the content in some cases ". I would expect data is the
(organisation-wide) database to be accurate; if it's not, there's not much
point in having the database, if people can edit the output from the
database (in this case, as a Word file) to be what they want. For that
reason, I would normally export to a non-editable report format (either .snp
or .pdf - the latter is preferable as almost every system will have a pdf
reader installed). If the report recipients notice something is wrong, it
should be amended in the database, and the report re-generated.

Hope you appreciate the philosophy of what I'm suggesting;

Rob

Hi Rob Parker,

Thanks a lot for your answer. Even though I give inside Report Header ,its
still the same, And as you told I can see the Logo and border when I take
a
Snapshot output.

My concern is after taking the output still there needs human intervention
to edit the content in some cases , so that puts me to same situation
where
I need all these graphics and still I should be able to edit the document
as
well, :-( is there any way for this ?

thanks for your help

Raj

Hi Raj,

I guess that your logo is a picture/image, and the page border is
probably a
box. If you export an Access report to Word, you lose all graphic
elements
such as picture/images, and lines/boxes. The only formats in which these
elements are retained are by printing to a .pdf file, or exporting to a
Snapshot format file.

HTH

Rob

Hi All,

I am using MS Access 2003 version.I have Logo and Page border
(displayed
using Code) [Placed inside Report Header]and other fields taken from
DB.The
problem is while preview,I am able to see all this,but once I create
the
Word
document either by Publish or by Export options.The logo and page
borders
become invisible.Please help me on this,its very urgent.

thanks and regards

Raj

 

[Larry Linson]

My concern is after taking the output still there needs human intervention
to edit the content in some cases , so that puts me to same situation where
I need all these graphics and still I should be able to edit the document as
well, :-( is there any way for this ?

You have been, quite correctly, advised that with considerable effort, you
can create the Word document directly from code (and it may be helpful to do
so in code that executes in Report events), so that it is not tied to an
export / import of an Access Report.

An alternative, perhaps, is to create a mail merge data list and use it with
a Word document to create the output you require.

Yet another alternative is to "require human intervention" every time, and
reinsert the logo and graphics manually into the Word document, if using a
Word template doesn't seem an acceptable alternative, or generating the Word
document from code, or, any of the other workable solutions.

It would be nice if asking the question again would lead to a different
answer, but "publishing to Word" or "exporting to Word" from Access actually
creates a .RTF file-format document, and Access does not support
pictures/graphics in export to .RTF.

Finally, visit the site of MVP Stephen Lebans, http://www.lebans.com... he
has some very suprising controls and information... and what you want might
be included. Rather than invest my time and effort in going to Stephen's
site and searching, I want you to do that, as you might well find some other
things that would be helpful.

As the standard option in Office 2007 is that the Word output is in XML,
there's some possibility that what you want to do can be more easily
accomplished in 2007 than in previous versions. I'm just getting Office
2007 set up on another PC, so couldn't explore for you, even if I had the
time for that "research".

Larry Linson
Microsoft Office Access MVP