Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running a report automatically on a monthly basis

Status
Not open for further replies.

MHUK

Programmer
Nov 30, 2002
139
GB
Hi

Please can someone help me? Is it possible to have an Access 97 report run automatically on a regular (user-defined) basis?

I have already created the report, but was wondering if there was an automatic way of actually running it on a particular date and time? Is there some kind of MS DOS batch file I can create to enable this?

I'm on Windows 98 - is there someway to link up my database and report to the Windows Scheduler? I dont know much about Windows Scheduler - please can anyone help.

Thank you for any help.

MHUK
 
See thread68-498544
You need to create a macro that runs the report then use the command line syntax to open Access and call that macro. Haven't used HAL yet, but it looks a good little facility
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top