DoCmd.SetWarnings False

Discussion in 'Access Table Design' started by fishqqq@hotmail.com, Mar 14, 2011.

  1. Guest

    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
     
    , Mar 14, 2011
    #1
    1. Advertisements

  2. Ken Snell Guest

    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/


    <> wrote in message
    news:...
    >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
     
    Ken Snell, Mar 15, 2011
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Bart

    vbYesNo not working with DoCmd

    Bart, Feb 18, 2004, in forum: Access Table Design
    Replies:
    2
    Views:
    113
    John Nurick
    Feb 19, 2004
  2. Robert

    what is wrong with my DoCmd syntax?

    Robert, May 18, 2006, in forum: Access Table Design
    Replies:
    2
    Views:
    99
    Robert
    May 18, 2006
  3. Slez via AccessMonster.com

    DoCmd.GoToRecord question

    Slez via AccessMonster.com, Jan 10, 2007, in forum: Access Table Design
    Replies:
    2
    Views:
    117
    Slez via AccessMonster.com
    Jan 10, 2007
  4. lmcc007

    Syntax error when using DoCmd.OpenForm

    lmcc007, Aug 6, 2009, in forum: Access Table Design
    Replies:
    2
    Views:
    111
    lmcc007
    Aug 6, 2009
Loading...