Electronic Reports

[camidon]

I have created some reports in Access 2000 for my manager and she would like to be able to send this data electronically. The problem is when I export my report to Word it really doesn't look right and it drops a great deal of formatting. Can anyone suggest a better way to send these reports in electronic format so that they still look as nicely as they were designed in Access??

Thanks!

Chris

 

[JoeMiller]

Snapshot format is the best format that comes natively from access. All the others drop formatting. The viewer of the SnapShot file is a free download from

http://www.microsoft.com/downloads.

Joe Miller
joe.miller@flotech.net

 

[Smack]

I have not used it, but i have heard snapshot maintains formatting. Otherwise, you have to be creative when you develop reports, because you will lose all lines, boxes etc. I have even used a text label and entered----------------------------------------------------------------- just to show a record break. Good luck.
-Smack

 

[camidon]

If I use sendobject from Access does it drop formatting?

 

[JoeMiller]

Not if you use the SnapShot format, all other formats have the potential to lose formatting.

Joe Miller
joe.miller@flotech.net

 

[camidon]

Unfortunately, my manager does not want to utilize snapshot because we are working in a large corporate environment and it would take an act of congress to pass something like snapshot through QA.

So somehow I have to find a way to maintain formatting without 3rd party software. I guess I'm on an impossible endeavor.

 

[JoeMiller]

SnapShot is not third party software. It's developed by Microsoft as a viewer for Microsoft Access. I don't know if that helps or not, but thought you should know.

Joe Miller
joe.miller@flotech.net

 

[camidon]

I agree with you totally, my QA department doesn't agree with me. I'll let you do the math.

What about outputting to HTML? How is that done?

 

[Smack]

HTML will give you multiple individual pages to open, that in itself kept me from pursuing further. If you go back and forth from access to word, you can figure out a way to make it look decent. You may want to investigate mail merging records with a word document. If the reports are fairly static, this could be an option.
-Smack