Hide the windows based system message

• • Reply

  14 years ago

  by enzom

  Enzo Calcagno

  Montreal, Canada, Canada

  Joined 15 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

   

  Report abuse
• • Reply

  14 years ago

  by enzom

  Enzo Calcagno

  Montreal, Canada, Canada

  Joined 15 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...!

   

  
   
  

  Report abuse