How to Silence messages on Make Table query?

J

Jeff

How do you silence the following messages when running a make table query?

"you are about to run a make-table query that will modify data in your
table....."

"The existing table will be deleted before your run the query....."

"You are about to post xxxx row(s) of data into a new table..."

I don't want to spoof the user..

thanks
 
N

NTC

investigate: SetWarnings

if a macro you are using just add that line at beginning and set to No
 
F

fredg

How do you silence the following messages when running a make table query?

"you are about to run a make-table query that will modify data in your
table....."

"The existing table will be deleted before your run the query....."

"You are about to post xxxx row(s) of data into a new table..."

I don't want to spoof the user..

thanks
Click to expand...

Using Code?

DoCmd.SetWarnings False
Docmd.OpenQuery "YourQueryName"
Docmd.SetWarnings True

Or rather than using the OpenQuery method, use the Execute method,
which does not require setting Warnings to False, then True:

CurrentDb.Execute "YourQueryName", dbFailOnError
 
J

John W. Vinson

How do you silence the following messages when running a make table query?

"you are about to run a make-table query that will modify data in your
table....."

"The existing table will be deleted before your run the query....."

"You are about to post xxxx row(s) of data into a new table..."

I don't want to spoof the user..

thanks
Click to expand...

Just one suggestion: MakeTable queries are *very rarely* actually necessary;
they're inefficient; they bloat your database; they give no control over field
sizes or datatypes...

What is the purpose of this maketable? What will you do with the new table
which cannot be done with a Select query?

In other words... quoting the WWII poster... "Is This Trip Necessary?"
 
Top