Outputing reports to word with formatting

D

Dave

Hi

I have an access report with various logos/lines and other type of
formatting on it.

And am using the following code to output the report to word

DoCmd.OutputTo acOutputReport, "rptWordDocument", acFormatRTF,
strOutputFileName, False

Which works fine and out puts the file as expected, but does not
output the formatting such as logos and drawn lines etc. Is there any
way to do that?

Thanks

Dave
 
D

Douglas J. Steele

Dave said:
Hi

I have an access report with various logos/lines and other type of
formatting on it.

And am using the following code to output the report to word

DoCmd.OutputTo acOutputReport, "rptWordDocument", acFormatRTF,
strOutputFileName, False

Which works fine and out puts the file as expected, but does not
output the formatting such as logos and drawn lines etc. Is there any
way to do that?

Not with the built-in functionality.

Take a look at what Stephen Lebans has at
http://www.lebans.com/ReportUtilities.htm though.
 
D

Dave

Not with the built-in functionality.

Take a look at what Stephen Lebans has athttp://www.lebans.com/ReportUtilities.htmthough.

Doug

Thanks for your reply - this looks as though it is likely to do the
trick. The only problem is that I will need to set a reference to an
mde that Stephen has attached to the utility and my client (who needs
this functionality) will not be to keen (to put it mildly) on
installing code on there system that they are unable to review.
Obviously this is possible - are you aware of any other sites where
the code is available (ie not as an mde)?

Dave
 
D

Douglas J. Steele

Dave said:
On Aug 12, 11:15 pm, "Douglas J. Steele"

Doug

Thanks for your reply - this looks as though it is likely to do the
trick. The only problem is that I will need to set a reference to an
mde that Stephen has attached to the utility and my client (who needs
this functionality) will not be to keen (to put it mildly) on
installing code on there system that they are unable to review.
Obviously this is possible - are you aware of any other sites where
the code is available (ie not as an mde)?

Given Stephen wrote the code, it had better not be on any other sites in a
different format!

I haven't bothered looking, but I see that the Access 97 version includes
the source code: perhaps the other ones do as well.

You could try dropping Stephen a line, although there's no guarantee he will
reply (especially since he's taking the summer off). You could also post a
note to him in microsoft.public.access.reports, as I've seen him peek in
there from time to time recently.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top