Solved

If record exists

Posted on 2001-06-04
1
126 Views
Last Modified: 2010-05-02
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.
0
Comment
Question by:fayb
1 Comment
 
LVL 15

Accepted Solution

by:
robbert earned 50 total points
ID: 6152291
No. If there is no sName in the database, the DELETE statement will not have any effect.
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to debug this code 7 64
Microsoft Access combo box help 2 50
Sub or Function is not defined 6 43
VBA - If Bookmark = "XXBOOKMARKXX" then 15 41
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question