Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by KonaAl, Jul 28, 2006.

  1. KonaAl

    KonaAl
    Expand Collapse
    Guest

    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
    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
    use a form for input?

    Thanks for any advice. Best regards,

    Allan
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---Me Before You Theatre, Movies & Cinema Jun 5, 2016
    Life Before Sikhi? Questions and Answers Mar 27, 2016
    did sikh gurus before guru gobind singh ji wear the 5 k's etc? Blogs Oct 22, 2015
    Movies Ashdoc's movie review---The world before her Theatre, Movies & Cinema Jun 9, 2014
    Samagam... wearing dastar before Amrit? Questions and Answers Apr 20, 2014

  3. REM7600

    REM7600
    Expand Collapse
    Guest

    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
     
  4. KonaAl

    KonaAl
    Expand Collapse
    Guest

    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.
    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

    >
    >
    >
     

Share This Page