export report with graphics to Word

C

Chris

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

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
 
C

Chris

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

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

Chris said:
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.
Click to expand...
 
C

Chris

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

Chris

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.


Chris said:
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.
Click to expand...
 
E

Ed Robichaud

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

Chris

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

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

Chris

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

gls858

Chris said:
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.
Click to expand...

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
 

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

Similar Threads

Access 2002 change report header text 0
Weekly Report 2
VBA concatenate ranges into a new document 0
exporting graphics to Word 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
How to export html text as word document with specific size and orientation 0
Export Report with Graph to Excel error 2495 1

Top