Hide the windows based system message

  • 14 years ago

    Hi,

     

    I have this in a VBA script in Access 2002

    Dim strDel As String
        strDel = "DELETE * FROM TABLE_EVENEMENTS " & _
                "WHERE No_Even = '" & Me.num_text & "'"
               
        DoCmd.RunSQL strDel



     

    It does the delete...but I want to get rid off the windows message that one record will be deleted...!

    Thanks

     

  • 14 years ago

    I've just found the solution

     

    Dim strDel As String
        strDel = "DELETE * FROM TABLE_EVENEMENTS " & _
                "WHERE No_Even = '" & Me.num_text & "'"
          


             DoCmd.SetWarnings (False)

             DoCmd.RunSQL (strDEL)

             DoCmd.SetWarnings (True)

     

    I hope this will answer somebodyelse...!

     


     

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“PHP is a minor evil perpetrated and created by incompetent amateurs, whereas Perl is a great and insidious evil perpetrated by skilled but perverted professionals.” - Jon Ribbens