Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    24

    Unanswered: Make Table Problem

    I am running multiple queries off of a Make Table which is running multiple queries off of several tables.

    I then have a report with several subreports displaying the data.

    The reports are giving totals from many many many queries. This was only way to do it.

    My problem is that the reports are not updated until I manually run each of the query make tables.

    Is there a way to automatically run a make table before running the reports?

  2. #2
    Join Date
    Apr 2002
    Posts
    139
    Link all your queires together using a macro, and put the report as the last macro action.

    If you like, you can convert your macro to VBA and have a further go there.

    hth

  3. #3
    Join Date
    Jan 2003
    Posts
    24
    If you create the Macro that calls all of the make tables, how can you automatically enter values into the dialog boxes that pop-up, stating that it is ok to paste rows, etc.?

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    VBA To supress error messages

    DoCmd.SetWarnings False


    reset it after running your procedure

    DoCmd.SetWarnings true
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Jan 2003
    Posts
    24
    Excellent...It worked like a charm.

Posting Permissions

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