How to run a make table qry from switchboard

[Rachael]

I have built a switchboard that runs reports.

All of the reports are built from queries which have a common table. That
table is built from a make table query.

Question: How can I run the make table query from the switchboard so that
my data is up to date?

THANKS

 

[Rachael]

OK...I figured out how to get the Query to run...So now, how do I Supress the
question windows and get them to automatically select "Yes" so the Make table
will run without the user having to select Yes to delete and Yes to run?

Thanks

 

[Douglas J. Steele]

Assuming you're using a macro, SetWarnings False before running (and it's a
good idea to issue SetWarnings True after running)

If you're using VBA, using the Excecute method of the Database object is
superior.

 

[John W. Vinson]

All of the reports are built from queries which have a common table. That
table is built from a make table query.

Why?

Reports can be - and should usually be - based on a Select query. Running a
MakeTable query is just an added step that takes more time, bloats your
database, reduces flexibility, and is generally a Bad Idea.

Are you certain that you need a MakeTable at all???

 

[Rachael]

Thanks. How do I "SetWarnings" to False? In the "Action" column on the
macro that is not an option?

Thanks again for the help.

Also, If I want the query to allow me to add a criteria to one of the
fields when I run the query from the switchboard, how would I do that?

thanks again

 

[Douglas J. Steele]

What version of Access are you using? Access 2007 "hides" a number of macros
unless you click on the Show All Macros button on the ribbon.

To be prompted for input by the query, put something like [What value do you
want to use?] as the criteria (the wording isn't important: the critical
part is the square brackets at the beginning and end)

 

[Rachael]

originally I set it to look at the table to make the queries run faster. I
changed it back to run from the Query itself.