Run & Export Access Reports - How to Automate This?

[Barber_91]

I work in a hospital, and last week I created a report (in Access) for every "specialty" in the hospital. That means I have about 25 reports that need to run pretty much once a week.

Each "report" is exactly the same but uses a different query, that's how I seperate the departments/divisions out. I know what you're thinking...can't I just run one big report and sort by specialty.....well, not really because I have to send each specialty's report to them directly, so one area cant see another's report. I'd need a way to split it up if I did that.

Anyways, is there something I can do to automate the export of the query results to rich-text. Any WORD file would work, I just thought Rich Text was easiest.

If we get that far, then I can ask the next question about automating one more little thing

Thanks!

 

[MyBoo]

Your report could have breaks in it at the Dept/Div changes, causing page breaks to keep the reports seperated.


You could create one or more macros to run the individual reports/queries/macros. This will also allow you to export (TransferText), but there are limits.

You could create a form that contained one or more buttons that when clicked, would run your reports/queries/macros.

You could create a form that when opened would run your reports/queries/macros.

You could set this form (last example) in Tools/StartUp/Display Form/Page. Then, when you open the .mdb, the form would open and run the reports/queries. Put a statement in the (assuming your running under Windows) scheduler and it will run automagically. PS... you need to add something to exit the program too.

 

[VicRauch]

Because you want to run a separate report for each Specialty, you could create a table of Specialties, then use this table in VBA to provide the criteria to your report that you want to export. Depending on where you are exporting the reports, like to a specific folder for each Specialty, then that folder path could be stored in the Specialty table. This way, your 25 reports would be done within one VBA module, and the reports would be distributed as they are created.
Just an idea I had.