Automatic Report Generation

[Yeahyeahyeah]

Hello,

Part of my job involves keeping tabs on unusual incident reports. Everytime
a report comes in, a follow-up report has to be filed with our regulators at
30-, 60-, and 90-day intervals after the initial incident. As simple as this
might sound I have a difficult time keeping on top what follow-ups have to
filed by what time.

I already have a report that produces a timeline based on today's date
however what I want to know is two things:

1. Is is possible to have Access generate the report automatically at a
regular interval (like every Monday morning)? And is it possible to have the
program do this without even starting Access up?

2. Is it possible--once Access generates this report--to have the program
automatically email it to my regional managers via Outlook?

Any help on this would be tremendously appreciated.

Thanks
David

 

[NthDegree]

Might want to try this:

Create a module that contains a function (not a sub) that will contain code
to run the report, email it and then quit the application (docmd.quit).

Then create a macro named autoexec and within the macro have a line for
runcode activity and select the function you created above.

Using Windows (or some other scheduler) use the following format for a
command line:

c:\(install directory for Access\msaccess.exe somefolder\somemsappname

When it starts up it will automatically run the function that will produce
the report, email it, and shut down Access.

One caveat, if using Outlook for email because of the built in security
Outlook will present a message saying "A program is attempting to send out
email, possible virus threat, do you wish to continue" or some similiar
nonsense which you will have to reply to. If you are using Exchange Server
you can get around that.