Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    5

    Unanswered: Automate similar parameter queries

    I have several queries which I need to complete month-end reports. Using parameters, I can ask for a year (2004) and a month(7) to get the July reports. However, for each query I need to enter the same parameters. Is there a way in Access to only enter these parameters once? If so, how?

    Thanks for your help,

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Like you always want the current month's report? and not last month's? Or do you mean you open it and hit 7 2004, close it and it already knows that it should pull 7/2004?
    Ryan
    My Blog

  3. #3
    Join Date
    Jul 2004
    Posts
    64
    How are you opening the reports? You could try opening them from a module, and then just assign values at the beginning, and they would be carried through until all the reports were finished.

  4. #4
    Join Date
    Jul 2004
    Posts
    5
    Scenario: Seven different reports each using a different query. At month end I want to enter the year and month once (for all seven reports)...Next month will be a different month (and possible year).

  5. #5
    Join Date
    Jul 2004
    Posts
    5
    Right now the reports are running from the Reports tab. I know how to run them from a switchbox.

    Could you give me a code snippet for your suggestion in a module?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •