I would lke to generate a report every month automatically without human
intervention. I've heard of things such as CRONs that run on servers - can
something similiar be used to fire up MS Access on a specific time and
produce a report - then, for the Gold star - e mail the report to recipiants.

I was thinking on the lines of using a Windows task schedule to run MS
Access, then use a macro to automatically generate a report, but how does the
e-mail part work.

I can transfer a report into .pdf automatically. Im guessing Im almost
there (in theory) - but not quite!

Can anyone help?

--
Learning SQL and Access

Hi,
check this current discussions for pointers on things you are trying to
achieve as well:

http://www.microsoft.com/office/comm...5-4c3f00ff595e

The PDF part will be a problem. Current Access editions do not support the
PDF format. Access 2007 will natively support it, but for now you need to
implement a workaround.
If you have a pdf driver installed you can change the printer at runtime
(using the Printer object if you are using Ac2002 or higher) to print out a
file with it...if you don't then you can implement an automation method using
the free ghostscript or have a look at this nice solution:

http://www.lebans.com/reporttopdf.htm

You would then need to use automation (since the sendobject method can't
attach external files) to create an email and attach the file.
If you don't care about the file type of the report then just use the
sendobject method and attach the report as snp (snapshot format which will
also retain the exact format of the report, but requires the free snapshot
viewer to be installed to view the report) or rtf (rich text format which
might lose some graphical things if you have them on your report).
Finally you might also find this article helpful:

http://support.microsoft.com/kb/230575

HTH
Good luck
--
Oli-S
Admin Specialist & Computer Science Major @ UMD - Go Terps -
http://www.oli-s.de


"stephenson22" wrote:

> I would lke to generate a report every month automatically without human
> intervention. I've heard of things such as CRONs that run on servers - can
> something similiar be used to fire up MS Access on a specific time and
> produce a report - then, for the Gold star - e mail the report to recipiants.
>
> I was thinking on the lines of using a Windows task schedule to run MS
> Access, then use a macro to automatically generate a report, but how does the
> e-mail part work.
>
> I can transfer a report into .pdf automatically. Im guessing Im almost
> there (in theory) - but not quite!
>
> Can anyone help?
>
> --
> Learning SQL and Access

Absolutely brilliant.

Thank you.
--
Learning SQL and Access


"freakazeud" wrote:

> Hi,
> check this current discussions for pointers on things you are trying to
> achieve as well:
>
> http://www.microsoft.com/office/comm...5-4c3f00ff595e
>
> The PDF part will be a problem. Current Access editions do not support the
> PDF format. Access 2007 will natively support it, but for now you need to
> implement a workaround.
> If you have a pdf driver installed you can change the printer at runtime
> (using the Printer object if you are using Ac2002 or higher) to print out a
> file with it...if you don't then you can implement an automation method using
> the free ghostscript or have a look at this nice solution:
>
> http://www.lebans.com/reporttopdf.htm
>
> You would then need to use automation (since the sendobject method can't
> attach external files) to create an email and attach the file.
> If you don't care about the file type of the report then just use the
> sendobject method and attach the report as snp (snapshot format which will
> also retain the exact format of the report, but requires the free snapshot
> viewer to be installed to view the report) or rtf (rich text format which
> might lose some graphical things if you have them on your report).
> Finally you might also find this article helpful:
>
> http://support.microsoft.com/kb/230575
>
> HTH
> Good luck
> --
> Oli-S
> Admin Specialist & Computer Science Major @ UMD - Go Terps -
> http://www.oli-s.de
>
>
> "stephenson22" wrote:
>
> > I would lke to generate a report every month automatically without human
> > intervention. I've heard of things such as CRONs that run on servers - can
> > something similiar be used to fire up MS Access on a specific time and
> > produce a report - then, for the Gold star - e mail the report to recipiants.
> >
> > I was thinking on the lines of using a Windows task schedule to run MS
> > Access, then use a macro to automatically generate a report, but how does the
> > e-mail part work.
> >
> > I can transfer a report into .pdf automatically. Im guessing Im almost
> > there (in theory) - but not quite!
> >
> > Can anyone help?
> >
> > --
> > Learning SQL and Access