Automatic Report Generation

[holzmerd]

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

[Pachydermitis]

Are you up to playing with vb? If so you can really do practically
anything at all.
Some docmd functions to look at are openreport, sendobject

If not you can try macros, or use the automation wizard on the forms.
If you create a new forn and then add a new button, Access can generate
code for you.

You can also put the database on your windows timer so it opens every
monday does it's thing and then closes.
Hope that points you in the right direction
P

ho******@hotmail.com wrote:

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