UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Get rid of Append Message Box    
 
   
Tharxa
post Aug 8 2006, 08:40 AM
Post #1

UtterAccess Addict
Posts: 114
From: Horseheads, NY
How do I stop Access from prompting me every time I want to append a record? I know there has to be an easy way to do this.
Go to the top of the page
 
+
freakazeud
post Aug 8 2006, 08:43 AM
Post #2

UtterAccess VIP
Posts: 31,413
From: NC, USA
Hi,
execute your action queries with:

CurrentDb.Execute "YourQueryNameOrSql", dbFailOnError

HTH
Good luck
Go to the top of the page
 
+
Tharxa
post Aug 8 2006, 08:49 AM
Post #3

UtterAccess Addict
Posts: 114
From: Horseheads, NY
Thanks, I always wondered why people advise not to use DoCmd RunSQL.
Go to the top of the page
 
+
freakazeud
post Aug 8 2006, 08:53 AM
Post #4

UtterAccess VIP
Posts: 31,413
From: NC, USA
It would require you to adjust the setwarnings property which means that even if the query errors out for some reason you will not see that. The .execute method surpresses the warnings as well...but still errors out when something goes wrong. Furthermore, it can run faster and prevent bloat on large recordsets.
HTH
Good luck
Go to the top of the page
 
+
« Next Oldest · Access Q and A · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 07:59 AM