Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Slovenia, EU
    Posts
    16

    Question Unanswered: Hide MsgBox for inserting Line with SQL

    Hi,

    I prefer inserting data form form to table with VBA DoCmd.RunSQL, but the promp windows from the system become really annoying. Is there a possibility to turn them off so that there is no Yes/No MsgBox when you insert new line into table?

    Thanks!
    MS Access 2000 - 2003, WinNT - WinXP

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Use DoCmd.SetWarnings False before the DoCmd.RunSql and DoCmd.SetWarnings True after it

  3. #3
    Join Date
    Nov 2003
    Location
    Slovenia, EU
    Posts
    16

    Thank you!!!

    Thats what I needed!
    MS Access 2000 - 2003, WinNT - WinXP

Posting Permissions

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