Making reports that stick

[Maxis]

Hey, I've only grasped a small bit about access and could use some help. I'm trying to put together a property management program and I'm stuck on the reports. I'm trying to create reports that are saved with a name that is dependand on the date range the report is inquireing about. I also wish to reference changes in old numbers by rechecking the final balance of the previous month report against the begining balance of the new report I'm creating. Any insite would be appreciated. I would not be at all offended if it turns out I missed something obvious.

 

[DonQuichote]

A report as it is saved in the MS-Access database is merely a template that needs data to produce the output you see on screen or paper. This means that if you feed it last month's data, you get last month's results. If you feed it this month's data, you get this month's result. All from the same report.

If you really want the data on it to be saved, you can either keep paper copies or export the report to Word or Excel.

Best regards

 

[MakeItSo]

You do not have to export directly to Word,
You could in fact save it from Access as RTF:

DoCmd.OutputTo acReport, "YourReport", "RichTextFormat (*.rtf)", "Full file name with path", False, ""

The same is valid, if you do not want it as code, but as macro:
Create a new macro, say "OutputTo" and set all necessary values.
Beware: I do not know, what RTF will do to your report if it contains any MS Graph objects or stuff like that. You might then try HTML...


Regards,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[dante1963]

You can also export it to snapshot format. (.SNP), this will save all of the graphics and formatting. However, the user may need to download the free viewer from Microsoft to open it.