LAUNCHING A TIME DRIVER REPORT

[baudouxnorthrup]

I have this database of incidents within a chemical plant. The security folks input each incident into the database and generate a full report for each incident.

Every incident report goes to the plant manager, environmental manager and safety manager....so, in essence if we have 20 incidents a day, they get 20 reports.

My boss, the environmental manager, wants me to figure out a way to send the 3 managers a consolidated report for all incidents each day. I do not know of a way for Access to automatically launch a report without someone going into Access and sending it.

Is there a way?

 

[beetee]

If you're running NT and have access to the scheduler, you can execute the report that way.

To do this, you will probably want to take advantage of program arguments to access. You launch the program using a command such as :

c:\program files\...\Access.exe <path to my db> /x macroname

Check out the help on 'Startup command-line options'

You can then have the macro open the reports, or write some code to open the reports.

-------------

Another way is to have the database running constantly, using a form with a timer event; when a given time is reached the reports are created (e.g.
if Now >= NextReportTime then
' print the reports
NextReportTime = int(now + 1) + 17/24 (for 5:00 PM)
end if