Exporting Report from Access97 to Word, Keep format

[cruz610]

I need to keep all the graphics, lines etc that are in my report but I also need to be able to email this report to other people. Am I looking at a limitation of Access97 and will I have to upgrade in order to be able to do this? Thanks!

 

[Crowley16]

frankly, I'm using access2002 and I can't get the export to keep it's format...

what I do is to export it as a snapshot file...
however to be able to view a snapshot file, you'd need to have a postscript compatible printer installed.

Apparently there are export to pdf modules available, not sure where to get them though...

 

[tcace]

The Snapshot viewer should work with any printer installed on the local workstation.


Think of the snapshot file as a "Portable Document Format" for Access reports.

 

[ekim]

FYI Snapshot is not an editable document

 

[ashij]

Hey Guys, I'm not much of a script guy, but I think one of the ways to solve this is if you have microsoft word 200 or later (XP and 2003). I work on MS Office 2003, but I just went to a workstation with MS Office 2000 and checked the features availibility.
MS Access does let you change your access reports into Word or Excel. To try this, go ot: "Tools" (and expand the menu) --> click on "Office Links" --> "Publish It With Microsoft Word".
the problem that I faced though is that Word doesn't treat MS Access Page Headers and Footers and Page headers and Footers, but just oridinary text. It'll also not see your other formatting that you might have done in Access. Hope this helps.

AshiJ