make table query run before report

Topic

New Reply

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?

Reply | Quote

Replies

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.

Reply | Quote

Thank you — fast response and works great! Pat

Reply | Quote

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

Reply | Quote

Good point — thank you, Pat

Reply | Quote