Auto Run Make Table Qurey

[scamquist]

I have set up a group of make table queries that run sequentially from a macro. The problem is that I want them to run automatically. Before the query will run, it stops to inform me that it will run a query that will make a table, then stops again to ask if it may overwrite the existing table.

Is there any way to auto answer these questions?

 

[BoxHead]

S,

I know you can use

DoCmd.SetWarnings False

in a code module to shut off the warnings. I've never worked with Macros so I'm not sure if it applies to you.


HTH

John

Use what you have,
Learn what you can,
Create what you need.

 

[scamquist]

DoCmd.SetWarnings False worked like a champ. Thank you.