Aug 8 2006, 08:40 AM
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.
Aug 8 2006, 08:43 AM
execute your action queries with:
CurrentDb.Execute "YourQueryNameOrSql", dbFailOnError
Aug 8 2006, 08:49 AM
Thanks, I always wondered why people advise not to use DoCmd RunSQL.
Aug 8 2006, 08:53 AM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here