Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 10th, 2008, 04:22 AM
Authorized User
 
Join Date: Feb 2008
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to hewstone999
Default Get rid of the "Update Messages"

I have a button that inserts values into a table. But every time is dose this, a update message appears. How can i change this so this doesn’t appear? Is it something to do with the security settings? or is there some code which automatically clicks yes? - I want to min user involvement.

Update Message

************************************************** ******************************
Your about to update 15 row(s)

Once you have clicked yes, you can't use the undo command to reverse the changes.
Are you sure you want to update these records?

YES/NO
************************************************** ******************************


Kind Regards
Richard


 
Old March 10th, 2008, 06:47 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

DoCmd.SetWarnings False

DoCmd. insert routine

DoCmd.SetWarnings True

HTH

mmcdonal

Look it up at: http://wrox.books24x7.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you get Rid of quotes hewstone999 Access VBA 1 April 15th, 2008 10:42 AM
How to get rid of everything except startup form. biglazy Access 9 March 23rd, 2006 07:33 PM
How do I get rid of this comma?!?!?!?! tsindos Classic ASP Databases 10 February 16th, 2006 12:55 AM
How to get rid of this comma!!?! gilgalbiblewheel Classic ASP Databases 15 August 8th, 2005 06:41 PM
How do I get rid of the last character in a string Lucy Classic ASP Professional 3 September 30th, 2003 05:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.