Re: OpenReport, PrintOut

Discussion in 'Microsoft Access Macros' started by Steve Schapel, Jul 18, 2003.

  1. Sam,

    I can't really give a specific answer, but maybe a general comment may
    help... I generally find it is easier to control the records that are
    included in a report by applying criteria to the queries that the
    report is based on, rather than via the Where Condition of the report
    print.

    - Steve Schapel, Microsoft Access MVP


    On Fri, 18 Jul 2003 06:50:52 -0700, "Sam H" <> wrote:

    >I have a macro that opens and prints out two sets of
    >documents. First it uses OpenReport:
    >[IndustryList]![Industry]=[Forms]![IndustryTemplate]!
    >[Industry]
    >to open a one/two page report on an Industry specified by
    >the user.
    >Then it uses PrintOut to print out the one/two page
    >Industry Report.
    >I then have another OpenReport that I want to use to print
    >out the CapitalIQ Reports on ALL (from 5-20) Companies
    >that are mentioned in the Industry Report. I currently
    >have:
    >[CapitalIQ]![CapitalIQTicker]=[Reports]![Industry Report]!
    >[CapitalIQTicker]
    >however the above code for OpenReport only prints out the
    >CapitalIQ report for the LAST Company mentioned on the
    >Industry report.
    >Is there a way to get the macro to print out the CapitalIQ
    >reports for ALL the Companies on the Industry Report.
    >Thanks,
    >Sam
     
    Steve Schapel, Jul 18, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Appending the where clause in "OpenReport"

    Guest, Apr 12, 2005, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    172
    Steve Schapel
    Apr 13, 2005
  2. G S via AccessMonster.com

    URGENT - OpenReport when Form closes

    G S via AccessMonster.com, Jul 20, 2005, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    175
    Steve Schapel
    Jul 20, 2005
  3. Guest

    Help with OpenReport Where Condition

    Guest, Nov 2, 2006, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    539
    Guest
    Nov 2, 2006
  4. K90267000 via AccessMonster.com

    OpenReport Macro (Newbie question)

    K90267000 via AccessMonster.com, Apr 17, 2007, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    288
    K90267000 via AccessMonster.com
    Apr 17, 2007
  5. tcosmas

    The OpenReport action was cancelled.

    tcosmas, Mar 11, 2009, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    461
Loading...

Share This Page