Macro to run Report

A

Allison

Thanks, I thought maybe I'm bugging the group to much!!!

My issues:
I have MS Access 2000!!!
I prepared a make table query that links up to an ODBC
table. My make table query is entitled: qryACTIVITY.
(Keep in mind this query has financial information that
changes daily). I copied the table over to the reports
object and played around to generate a report for the
managers to look at(the report is named ACTIVITY). The
problem I have is the report does not update when I hit
the make table query run icon.
Only my query updates(which is how Access is designed).
How can I have the report update each time the query does?
Is there a macro or an autoexecu macro that will help me
out??? Or any suggestions???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
New Bug in Track Changes in Word 365 0
Can I save a sql statement generated by a search form? 1
Consolidation Table from Different Excel Tabs with Different Format 1
Insert Index into a Table 1
How to stop reports printing with blank fields 2
A Report, based on query, called from macro is prompting for param 1
Slow running reports 0

Top