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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bart

    vbYesNo not working with DoCmd

    Bart, Feb 18, 2004, in forum: Access Table Design
    Replies:
    2
    Views:
    106
    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:
    93
    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:
    110
    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:
    104
    lmcc007
    Aug 6, 2009
Loading...