Over my head: Word report with graphics?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I write macros for Word and Excel. So naturally when someone needed help
with Access, they came to me??!?

A co-worker is creating an Access database. He has prior database
programming experience, but not with Access. When creating his report, he
put a JPG logo graphic at the top. But the "Publish to Word" command
apparently publishes as RTF, which means his graphic doesn't come across.
So he was asking me for a macro that would copy everything including the
graphic into Word (so he doesn't have to manually cut and paste and
reformat).

It doesn't sound difficult on the surface, but then again I've never done
anything in Access VBA. Is this something a newbie shouldn't try?

Ed
 
Access macros are a different animal than Word/Excel macros; they don't
"write" VBA code. someone in this group may be able to help you do what
you're asking by using a macro, but if you're hoping to do the task using
VBA, you might get more help by posting in the
microsoft.public.access.modulesdaovba group.

hth
 
Not possible with an ACCESS macro, to my knowledge. VBA code would need to
be used, and perhaps would need to use Word Automation to do that.
 
Tina and Ken - you have answered my question: this is not for me to try!

Thanks for the boost.
Ed
 
Ed,

The easiest way to output from an Access report while preserving all
graphics, is to save the report to Snapshot format, which is the report
output format that Access natively supports. This means that the
recipient will need to have the Microsoft Snapshot Viewer installed, in
order to see or print this document... Many computers already have this
these days, but if not it's a simple and free download and install from
microsoft.com.

The second easiest way is to install a PDF driver, and print the report
to a PDF file.

Both of these can be done using macros, or VBA procedures, in both cases
simple.
 
Back
Top