<div>
<div class="content wysiwyg-content">
In vb5, I have code that works fine to delete a record if the name is &quot;Brown&quot;<br />
<br />
sName = Brown<br />
Set dbtemp = OpenDatabase(dbname)<br />
&nbsp; &nbsp; dbtemp.Execute &quot;DELETE * FROM List1 WHERE Name = &quot;&nbsp;&amp; &quot;'&quot; &nbsp;&amp; &nbsp;sName &amp;&nbsp;&quot;'&quot;<br />
dbtemp.Close<br />
<br />
Do I need a trap in case there are is no Brown in the Name field.
</div>
</div>


In vb5, I have code that works fine to delete a record if the name is "Brown"

sName = Brown
Set dbtemp = OpenDatabase(dbname)
    dbtemp.Execute "DELETE * FROM List1 WHERE Name = " & "'"  &  sName & "'"
dbtemp.Close

Do I need a trap in case there are is no Brown in the Name field.

If record exists

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.