How to avoide the "Alert Messages" when using Queries

[galsaba]

When I run an "append query" or "Make a Table Query"
I get a pop up window alert message that alerts me that I am goint to
add rows, etc. How can I make my query that these alerts will not show
up?

Thanks,

galsaba

[pietlinden]

galsaba wrote:

When I run an "append query" or "Make a Table Query"
I get a pop up window alert message that alerts me that I am goint to
add rows, etc. How can I make my query that these alerts will not show up?

Thanks,

galsaba

You have to use
SetWarnings False

before you run the query and then

SetWarnings True

after so that the warnings get turned back on. Otherwise, you'll get
NO warnings at all after shutting them off.

[Steve]

You will only get these messages for action queries.

DoCmd.Setwarnings False
<<Run your query here>>
DoCmd.Setwarnings True

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"galsaba" <ga*****@aol.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

When I run an "append query" or "Make a Table Query"
I get a pop up window alert message that alerts me that I am goint to
add rows, etc. How can I make my query that these alerts will not show
up?

Thanks,

galsaba

[galsaba]

Is there a way to put it in the macro? how?

[fredg]

On 13 Feb 2005 09:35:19 -0800, galsaba wrote:

Is there a way to put it in the macro? how?

You can use a macro.
Place the Warnings False macro first, then the Open Query macro then
the Warnings True macro.

Perhaps it's time for you to start doing this in code. It's not hard
(just as easy as using a macro) and you get the benefit of being able
to add error handling when needed.

On the event line of whatever event you are using to start this
process, type [Event Procedure].
Then click on the button with 3 dots that appears on that line.
When the VBA code window opens, the cursor will be flashing between 2
already existing lines of code.
Write (between thos 2 lines):

DoCmd.SetWarnings False
DoCmd.OpenQuery "QueryName"
DoCmd.SetWarnings True

Change "QueryName" to the actual name of the query you are using.
Exit the code window and you're done.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Mark via AccessMonster.com]

If you want to start learning to use VBA code, you could use the
CurrentDB.Execute method. Using Execute instead of Open won't bring up
warnings for action queries, so you won't have to set warnings to False and
hope you don't forget to set warnings to True again.

Since Execute doesn't warn you even if there's a problem, you should
include the dbFailOnError option to the code:

CurrentDB.Execute "MyActionQuery", dbFailOnError

Then you can add some logic to your error-handling routine to handle the
error.

--
Message posted via http://www.accessmonster.com