How to make report automatically print out every morning? 1

[upplepop]

I am using a database that is hosted on a server and delivered to 5 client computers. I would like a report to automatically print out on everyone's printer in the morning. Does anyone else here do this type of thing? How can I set it up?

 

[Darrylles]

Hi,

Create a new Access application.

Create 'link-tables' in the db to the tables (in other databases) that you need for the report.

Create (or copy) your report in this application using the link-tables above for it's data.

Create a simple form in this application, make it the start-up form for the application.

In this forms' 'On Open' event - place code to run the above report. So, when you run the form - it just runs the report, then closes.

Use MS Scheduler to run your application when you want it.

Hope this helps,

Kind regards,

Darrylle






You need a simple form - in a simple Access application.

When the application is run, it automatically runs the form (it's the startup form) - this form automatically runs the report (from it's On Open event).

You have one application, it has the one form (above), and one report (above).

The application has link tables to the real tables in a different application.

The report uses these links to get it's data.

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[upplepop]

Great idea.
Thanks for your help.