PC Review


Reply
Thread Tools Rate Thread

DoCmd.SetWarnings False

 
 
fishqqq@hotmail.com
Guest
Posts: n/a
 
      14th Mar 2011
I would like to have a macro open a table, select all the records,
then delete them - without the user getting the popup box asking if it
is ok to delete the records.

I believe the correct command is DoCmd.SetWarnings False - to disable
the pop up boxes but can someone tell me where to put this command in
the table to disable these pop up boxes?

tks
 
Reply With Quote
 
 
 
 
Ken Snell
Guest
Posts: n/a
 
      15th Mar 2011
That macro action doesn't go in the table. It needs to be a step in the
macro that you run to open the table, etc.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


<(E-Mail Removed)> wrote in message
news:65e8acf7-57a8-48da-848c-(E-Mail Removed)...
>I would like to have a macro open a table, select all the records,
> then delete them - without the user getting the popup box asking if it
> is ok to delete the records.
>
> I believe the correct command is DoCmd.SetWarnings False - to disable
> the pop up boxes but can someone tell me where to put this command in
> the table to disable these pop up boxes?
>
> tks



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DoCmd.SetWarnings False is not working Jill Microsoft Access Macros 2 17th Jan 2008 04:08 PM
Re: DoCmd.SetWarnings = False problem with custom function Job Microsoft Access Form Coding 0 9th Aug 2005 04:44 AM
DoCmd.SetWarnings False does not suppress message Christine Microsoft Access Form Coding 6 28th Oct 2004 09:43 AM
Docmd.SetWarnings False but automatically answer No =?Utf-8?B?QnJpYW4=?= Microsoft Access VBA Modules 3 26th Jun 2004 06:49 AM
DoCmd.SetWarnings False Jenny Microsoft Access 3 15th Sep 2003 03:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:53 PM.