Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Location
    Minnesota
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    make table query run before report

    I have a report based on a make table query. (I am new to VBA but willing to keep trying,) How can I enter vba that would cause the make table query to run deleteing the old information and updating it with the new whenever I open the report?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: make table query run before report

    Hi. You can do this by a macro.

    In the action column of the macro,

    SetWarnings: to No (the SetWarnings to No will stop those pesky warning windows from popping open.)
    OpenQuery: to your makeTable query
    Close: your query
    OpenReport: to your report. Set the View to PrintPreview

    Pay special attention to the Action Arguments in the lower part of the macro design window for each of the four actions.

    This works well.

  3. #3
    New Lounger
    Join Date
    Feb 2001
    Location
    Minnesota
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: make table query run before report

    Thank you -- fast response and works great! Pat

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: make table query run before report

    You to set warnings back on or you're going to regret it down the road.
    Charlotte

  5. #5
    New Lounger
    Join Date
    Feb 2001
    Location
    Minnesota
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: make table query run before report

    Good point -- thank you, Pat

Posting Permissions

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