How do I save / export / print an MS Access report as some useful non-ugly file format?
by Pace on December 12th, 2007 @ 4:53 pm in
Off-Topic
Tags: Access, export, MS Access, pdf, print, report, save
We’re currently using MS Access for our accounting database, at least until I have time to rewrite it in Rails. All the export options built in to Access totally suck. RTF, HTML, Excel, they all come out looking horrible and ugly. I wanted to save the invoice report as some file type that we could email to our clients, so I needed it to look good. After a bit of googling I came across PDF995, a free PDF maker. It produces pretty good-looking PDFs and doesn’t stick an ad at the bottom of the file like some other free PDF creators I found out there. It has some annoying pop-ups when you run it, but that’s far less annoying than watermarking the actual PDF file. I just wanted to share what I found, since a simple google search didn’t immediately answer my question.
- Related posts:
- Alice and Betsy are about to miscommunicate unless you rush in to save them!
- The Five Keys to World-Changing Writing
- Saving $30 on dinner vs. saving $30 on a car
#1 Posted by
Paul on July 21st, 2008 8:30 pm | link
There are many good ways to export a report and I think experience with designing a good looking report to export would be extremely beneficial. Keep in mind that MSAccess isn’t the limiting factor in exporting reports as HTML or excel but designing the report to look good in an exported format is key. As far as working with exporting to a PDF, I detest working with PDF formats (and especially having to work with adobe’s irritating and constant popup messages and the fact that adobe thinks users like to have adobe silently install itself into the Windows startup and be a part of every report created.) PDF was great when it first came out but now it’s gotten to the point where the software thinks it should be number 1 for all exported report formats and doesn’t want to play nicely with anything else which might actually be better!)