Results 1 to 3 of 3

Thread: SQL Dialog Box

  1. #1
    Join Date
    Nov 2003
    Posts
    40

    Unanswered: SQL Dialog Box

    I am using Access to write a tool that will be used by "less technical" people and I use a lot of SQL statements. All the reports that are generated require at least one SQL statement. When the dialog box comes up asking if they are sure that they want to delete or append rows (the dialog box that comes up before the SQL statement executes) they freak out and say "no" which then gives them a run time error. Is there any way to just say "yes" to all the dialog boxes before they come up?
    Any help would be appreciated. Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    Right before you run the SQL delete statement put the following

    DoCmd.SetWarnings False


    This turns off the warning message so the users don't even see it and it will just execute.

    After running your statement

    DoCmd.SetWarnings True

    S-

  3. #3
    Join Date
    Nov 2003
    Posts
    40
    Wow, who knew it was going to be that easy!! Thanks!

Posting Permissions

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