Make - Append Table Query Question

[Marv Trott]

Hi,

I produced a report from a table that was created using a make table query
to make a copy of a linked table and then an append query to append a second
linked table to the copied table.

How can I force the make table query and append table query to function in
sequence automatically each time the report is run?

Thanks,

Marv

 

[Guest]

Use a macro to run the queries and then the report.

 

[Duane Hookom]

Or, even better, use code to run the queries. It is fairly easy to:
1) use the command button wizard to write code to open a report
2) right-click the button and edit the code
3) add your code to run your queries prior to the line of code that opens
the report

 

[Marv Trott]

Duane,

I understand what you described and had assumed that using code would be the
way to solve the problem. Since I have not written any code in Access I need
more details in your step #3. All the reports I have created are run from a
Switchboard setup using the Switchboard Manager.

Over the years I have written some programs in Basic and dBase so I can
understand code I just need more guidance on the overall approach.

I got as far as the Command Button Report Wizard but I could not find the
words "Open a Report" so I did a "Preview Report" and looked at the code.

Is this the correct code that will run the queries?

What is the code that will run the report?

How will I make a button on the switchboard created by the Switchboard
Manager run this code?

Thanks,

Marv

 

[Duane Hookom]

Create a form with a command button to open the report. Use your switchboard
to open your form.

Once you have the form and the button to open the report, review the code
and modify it by adding code to run your queries. You might want to check
Help in the module on DoCmd.OpenQuery or other.

 

[Marv Trott]

Duane,

Thanks for the suggestions.

I will try to learn how to use the DoCmd and OpenQuery and VBA programming
from my Access 2003 Bible.

Marv