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

Ask a Question

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.