General discussion

  • Creator
    Topic
  • #2092212

    Access 2000 and SQL INSERT statement

    Locked

    by ajd ·

    How do I stop Access 2000 asking “Are you sure you want to …” after each SQL INSERT statement. I have attached a macro to a combo box that runs a SQL INSERT every time a new value is selected. I want this to be transparent and not be prompted every time.

All Comments

  • Author
    Replies
    • #3879514

      Access 2000 and SQL INSERT statement

      by whyong ·

      In reply to Access 2000 and SQL INSERT statement

      before your sql statement, select “setwarnings” in the action tab, then set the “warnings on” to “No”.
      after runsql action, you can set the warnings on to “yes” again if you want to.

      hope that this is what you want… happy coding.

    • #3879439

      Access 2000 and SQL INSERT statement

      by bob sellman ·

      In reply to Access 2000 and SQL INSERT statement

      Go to Tools, Options.
      Select the Edit/Find tab.
      In the confirm box, uncheck Action Queries.
      You can also, if you want, uncheck the confirmation of record changes and/or document deletions.

      This also works in Access 97.

      • #3870133

        Access 2000 and SQL INSERT statement

        by ajd ·

        In reply to Access 2000 and SQL INSERT statement

        Thanks for the tip but I wanted a solution that I didn’t have to configure on every workstation.

    • #3870131

      Access 2000 and SQL INSERT statement

      by ajd ·

      In reply to Access 2000 and SQL INSERT statement

      This question was closed by the author

Viewing 2 reply threads