Append row message

's Computer Specifications

How can i turn off the message that appears to Append rowns "you are about to
append (1) rows" so that it does it without asking?

Many thanks

's Computer Specifications

DoCmd.SetWarnings False before you run the Append, and DoCmd.SetWarnings
True afterwards.

Alternative, you can use the Execute method of either the Database or
QueryDef objects.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Mike" <(E-Mail Removed)> wrote in message
news:1492376E-A37C-450D-A56B-(E-Mail Removed)...
> How can i turn off the message that appears to Append rowns "you are about
> to
> append (1) rows" so that it does it without asking?
>
> Many thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Brackets in the Append To row of an Append Query	DDogCap	Microsoft Access	2	22nd Jul 2008 09:54 PM
how to know which row to append for the last row	tango	Microsoft Excel Programming	2	16th Oct 2004 02:23 PM
can't append records in append query	Greg Clements	Microsoft Access Queries	1	2nd Jul 2004 04:29 PM
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B	Hannes Heckner	Microsoft Excel Programming	1	5th Mar 2004 10:10 AM
Append Query... Can't Create a Unique Number to Append	Vance	Microsoft Access Queries	8	17th Dec 2003 12:18 PM