Tags: access, database, date, enter, macro, method, microsoft, month-end, multiple, mysql, oracle, range, reports, retain, run, runs, sql

Set date range for multiple reports where reports run from macro

On Database » Microsoft Access

455 words with 1 Comments; publish: Thu, 03 Jan 2008 13:34:00 GMT; (250109.38, « »)

I'm looking for a method to enter and retain a start date and end date for use with a macro that runs 11 month-end reports that each require the same start date and end date.

FYI- currently, the macro runs and requires entry for start and end dates for each report as it opens. Where no data is available, the macro informs of no data, requires acknowledgement, then proceeds to the next report.

All Comments

Leave a comment...

  • 1 Comments
    • Don't do it from a macro, take the dates from a form.
      #1; Thu, 03 Jan 2008 13:35:00 GMT