Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Posts
    146
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Deletion Confirmations (2000 SP-3)

    I'm using a lot of make table queries that write over existing tables. I'm trying to suppress the table deletion message from the user's view. Help and user guides say that going to Tools > Options > Edit/Find tab and unclicking the confirm document deletions check box should fix this--but it doesn't make a difference. Is there another way to do this? I've hit both OK and Apply in the Options dialog box to try to make this happen.

    Thanks,
    Bob

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Deletion Confirmations (2000 SP-3)

    You must run the query from a macro or using VBA code (for example from a command button on a form)

    The macro would consist of three actions:

    SetWarnings, with argument No
    OpenQuery, with the name of the query as first argument
    SetWarnings, with argument Yes (to restore the normal situation)

    In VBA code, it would look like this (the code is for a command button named cmdRunQuery, and runs a query named QueryName)

    Private Sub cmdRunQuery_Click()
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "QueryName"
    DoCmd.SetWarnings True
    End Sub

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Deletion Confirmations (2000 SP-3)

    You may want to try turning off Action queries as well - Make Table queries are considered an action query. On the other hand, what you are proposing would give users no warning should they accidentally delete a table in your database - that might turn out to be a bad thing if it was one of your key tables. You would probably be better off to use the .SetWarnings property in VBA though it does mean writing some code.
    Wendell

Posting Permissions

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