export report with graphics to Word

[Guest]

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.

 

[Ed Robichaud]

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

 

[Douglas J. Steele]

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)

 

[Guest]

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.

 

[Ed Robichaud]

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
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.

 

[Guest]

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?

 

[Guest]

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?
--
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
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.

 

[Ed Robichaud]

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

 

[Guest]

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?

 

[Douglas J. Steele]

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.

 

[Guest]

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.

 

[gls858]

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.

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

 

[Douglas J. Steele]

They were supposed to with Office 2007, but Adobe threatened to sue.

 

[Guest]

And Adobe's probably too big for Micrsoft to buy out. Sure appreciate your
help.