Before I get too deep, I need advice about emailing reports...

Hello,

I’m in the middle of creating dashboard reports and while scanning this
message board for report solutions I happened upon some auto-email
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13573-before-i-get-too-deep-i.html
discussions. My report is by store branch for which a form pops-up
requesting store #, month & year that gets passed to several queries to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13573
create the report.

Now for the question: Is it possible to write VBA code to loop through the
store branches, prompting for month & year once – effectively ignoring the
form? Or should I create parallel queries/reports with parameters that don't
use a form for input?

Thanks for any advice. Best regards,

Allan

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

I'd opt for VBA myself... The parallel queries/etc always end up being a
maintenance nightmare down the road when things "change"...

REM7600


> discussions. My report is by store branch for which a form pops-up
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13573
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13573
> requesting store #, month & year that gets passed to several queries to
> create the report.
>
> Now for the question: Is it possible to write VBA code to loop through
> the
> store branches, prompting for month & year once - effectively ignoring the
> form? Or should I create parallel queries/reports with parameters that
> don't

Thanks for the reply, REM7600.

I don't think I clearly explained my situation. Currently to run a store
dashboard report, an access form prompts for the store #, etc. This works
fine when the finance staff needs to look at individual stores. But at month
end we'd like to send each store manager their relative report via email,
using VBA Code. However since the report/queries need input from the pop-up
form, can the code be written to bypass the form and instead have the fiscal
period/year requested once to apply to all stores?

I hope this helps clarify.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13573
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13573
Thanks!

Allan

"REM7600" wrote:

> I'd opt for VBA myself... The parallel queries/etc always end up being a
> maintenance nightmare down the road when things "change"...
>
> REM7600
>
>
> > discussions. My report is by store branch for which a form pops-up
> > requesting store #, month & year that gets passed to several queries to
> > create the report.
> >
> > Now for the question: Is it possible to write VBA code to loop through
> > the
> > store branches, prompting for month & year once - effectively ignoring the
> > form? Or should I create parallel queries/reports with parameters that
> > don't
>
>
>