How to Silence messages on Make Table query?

  • Thread starter Thread starter Jeff
  • Start date Start date
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
 
investigate: SetWarnings

if a macro you are using just add that line at beginning and set to No
 
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
 
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?"
 
Back
Top