Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    6

    Unanswered: How to eliminate "you are about to delete..." in Access?

    Hi!

    When running a macro, I made a "run command" with "command" [DELETE RECORD].

    This database will be used of several people and should be made "for dummies"...

    How do I get rid of the pop up alert "you are about to delete..." when running this command? Is it possible?

    The Delete Record command should delete the post in a table.

    Everything works, but I would like to get rid og the message appearing.

    Hope for a clue!!!

    Br

    Håvar Kvalbein,
    Stavanger, Norway

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    In the line preceding the "run command" in your macro, use
    Setwarnings, with the argument set to No.
    Inspiration Through Fermentation

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Remember to set warning to on when the routine is complete

  4. #4
    Join Date
    Mar 2003
    Posts
    6
    Originally posted by RedNeckGeek
    In the line preceding the "run command" in your macro, use
    Setwarnings, with the argument set to No.
    Hi!

    Thanks a lot!!!!!!!

    Håvar

  5. #5
    Join Date
    Jul 2003
    Location
    London UK
    Posts
    14
    You'll also find that setting the Tools|Options|Edit/Find tab checkboxes will help remove a number of these messages.

    I tend to leave these messages in until the last minute as they provide me with the confirmation that everything works as it's intended to, particularly as if your code isn't compiling correctly then you may not get any indication that it hasn't worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •