export report with graphics to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 26 Nov 2006 20:59 GMT

I'm using Access 2000 (XP pro) & have a number of reports with graphics
(check boxes, text boxes) that don't export to Word. I want to send the
reports as email attachments to non-Access users (can't use snap files). Is
there an easy way to change the check boxes in all the reports to Yes No &
delete the boxes around data without having to change each report? I'm not a
IT person & can't chance damaging the file.

Signature

Thanks for the help.

Reply to this Message

Ed Robichaud - 27 Nov 2006 14:50 GMT

As you've discovered, RTF files don't preserve the graphic portion of Access
reports. I see 3 options:
1. Overcome your reluctance of snapshots; the viewer is free
2. remove/convert the graphic elements in the report before printing to Word
3. print your reports to PDF; there are many free or cheap pdf printer
drivers

-Ed

> I'm using Access 2000 (XP pro) & have a number of reports with graphics
> (check boxes, text boxes) that don't export to Word. I want to send the
[quoted text clipped - 4 lines]
> a
> IT person & can't chance damaging the file.

Reply to this Message

Douglas J. Steele - 27 Nov 2006 14:57 GMT

4. Check what Stephen Lebans has at
http://www.lebans.com/ReportUtilities.htm (or, if you're going to go the PDF
route, at http://www.lebans.com/reporttopdf.htm)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> As you've discovered, RTF files don't preserve the graphic portion of
> Access reports. I see 3 options:
[quoted text clipped - 15 lines]
>> not a
>> IT person & can't chance damaging the file.

Reply to this Message

Chris - 28 Nov 2006 02:05 GMT

I'd like to export to PDF but I can't open the Report Utility, Access blocks
it as security risk. I turned off Windows Firewall & Norton Internet Security
but still couldn't open it. Also, it tries to open in my documents &
settings, shouldn't it open in Access program but Winzip doesn't provide
browser option.

FYI, I don't want to use snapshot as the reports will be used by many people
all over the world & I don't want to ask them to download anything to view
the report even though it's free.

Signature

Thanks for the help.

> 4. Check what Stephen Lebans has at
> http://www.lebans.com/ReportUtilities.htm (or, if you're going to go the PDF
[quoted text clipped - 19 lines]
> >> not a
> >> IT person & can't chance damaging the file.

Reply to this Message

Ed Robichaud - 28 Nov 2006 04:24 GMT

You may need to right-click on any downloaded mdb file and set its
properties to overcome the detected security risk. I don't recommend
turning off either your firewall or anti-virus program. BTW, pdf files also
need a free, downloadable program to read them.
-Ed

> I'd like to export to PDF but I can't open the Report Utility, Access
> blocks
[quoted text clipped - 37 lines]
>> >> not a
>> >> IT person & can't chance damaging the file.

Reply to this Message

Chris - 28 Nov 2006 18:53 GMT

What do you mean by "set it's properties to overcome the detected security
risk"? How do I do that? There are 3 files & theytried to open in my
documents & settings folder. Shouldn't they open in Access folder but where
do I find that?

Signature

Thanks for the help.

> You may need to right-click on any downloaded mdb file and set its
> properties to overcome the detected security risk. I don't recommend
[quoted text clipped - 43 lines]
> >> >> not a
> >> >> IT person & can't chance damaging the file.

Reply to this Message

Chris - 28 Nov 2006 19:17 GMT

I figured out how to open the files & copied DynaPDF.dll & StrStorage.dll to
Windows System 32 folder & verified they are there. Then I opened the
ReportToPDf.mdb file but not sure where it should be filed, it's in my
documents & systems temp folder now. I read the How To Use file but don't
understand what it means. How do I use the utility to convert a report to PDF?

Signature

Thanks for the help.

> I'd like to export to PDF but I can't open the Report Utility, Access blocks
> it as security risk. I turned off Windows Firewall & Norton Internet Security
[quoted text clipped - 29 lines]
> > >> not a
> > >> IT person & can't chance damaging the file.

Reply to this Message

Ed Robichaud - 28 Nov 2006 20:47 GMT

Most PDF converters install/work as a printer driver. When printing your
report, chose the PDF printer instead the default.
-Ed

>I figured out how to open the files & copied DynaPDF.dll & StrStorage.dll
>to
[quoted text clipped - 49 lines]
>> > >> not a
>> > >> IT person & can't chance damaging the file.

Reply to this Message

Chris - 28 Nov 2006 21:08 GMT

The ReportTo PDF.mdb file is still in my temp folder, it's not installed in
Access or the database I use so when I select a report PDF is not a printer
option. So where & how do I install the file?

Signature

Thanks for the help.

> Most PDF converters install/work as a printer driver. When printing your
> report, chose the PDF printer instead the default.
[quoted text clipped - 53 lines]
> >> > >> not a
> >> > >> IT person & can't chance damaging the file.

Reply to this Message

Douglas J. Steele - 28 Nov 2006 22:11 GMT

If you're talking Stephen's ReportToPDF.mdb, there's nothing to install.

Open the MDB file the way you would any other MDB, and take a look at the
code that's inside it.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> The ReportTo PDF.mdb file is still in my temp folder, it's not installed
> in
[quoted text clipped - 67 lines]
>> >> > >> not a
>> >> > >> IT person & can't chance damaging the file.

Reply to this Message

Chris - 29 Nov 2006 01:41 GMT

Yes, that's the report. But I'm not a programmer or IT person so I don't know
what to do with code. I'm just trying to use the utility within the database
I created to convert reports to PDF files so I can send them as email
attachements. Pretty simple request but like so many Microsoft products
nothing is easy. FYI, I'm also corresponding with Windows XP networking
discussion group trying to network 2 home computer so they can both use the
same printer & that's unbelievably difficult.

Signature

Thanks for the help.

> If you're talking Stephen's ReportToPDF.mdb, there's nothing to install.
>
[quoted text clipped - 72 lines]
> >> >> > >> not a
> >> >> > >> IT person & can't chance damaging the file.

Reply to this Message

gls858 - 29 Nov 2006 15:37 GMT

> Yes, that's the report. But I'm not a programmer or IT person so I don't know
> what to do with code. I'm just trying to use the utility within the database
[quoted text clipped - 3 lines]
> discussion group trying to network 2 home computer so they can both use the
> same printer & that's unbelievably difficult.

I use Cutepdf simple and easy to use. Sets up a printer in your printer
list. Simply chose it instead of your regular printer. It's free.

http://www.cutepdf.com/

gls858

Reply to this Message